Monday, September 11, 2017

Create custom short in QLikview?

Sometimes, we face scenario wherein we need to customize the sort in some specific order of values in Chart\tables.

By default we have option in qlikview to sort data in acceding or descending order.


In expression of Sort tab, use below

Match(Dim,'val1','val2','val3','val4')

or 

Minstring({1}WildMatch(DIM,,'val1','val2','val3','val4'))


Another scenario

how the sort order in a chart can be controlled by a user option.

  • Create a input box and set user input in variable lets say -  Vprimecustomer
  • in chart sort tab, check expression and use below formula

                       replace(match(Dim,'$(Vprimecustomer)'),0,1000)

this will show user input as first value in chart/table.

thanks,

1 comment:

  1. I feel there is a need to look for more and more aspects of solving complex IT and Qlik problems always associated with it.

    Qlik Soap API Connection

    ReplyDelete