topic Inline sort in QlikView

Inline sort

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me on this.

I have the calculated Dimension expression as

=if(Match(Deals,'No. 1 Top Deal','No. 3 Top Deal'),'No13Deals',

if(Match(Deals,'No. 5 Top Deal','No. 4 Top Deal'),'No54Deals',

if(Match(Deals,'No. 2 Top Deal'), 'No2Deals')))

Sort expression as

=if(Match(Deals,'No. 1 Top Deal','No. 3 Top Deal'), Dual('No13Deals',1),

if(Match(Deals,'No. 5 Top Deal','No. 4 Top Deal'), Dual('No54Deals',2),

if(Match(Deals,'No. 2 Top Deal'), Dual('No2Deals',3))))

Please let me know how to implement the above scenario in the backend with inline sort.

expected ouput is

Deals

No13Deals

No54Deals

No2Deals

Thanks in advance

Re: Inline sort

PrashantSangle — Thu, 16 Nov 2017 12:07:22 GMT

Hi,

try below

match(Deals,'No. 1 Top Deal','No. 3 Top Deal','No. 5 Top Deal','No. 4 Top Deal','No. 2 Top Deal')

Regards,

Re: Inline sort

shraddha_g — Thu, 16 Nov 2017 12:07:22 GMT

you can use this calculated dimension in script as

if(Match(Deals,'No. 1 Top Deal','No. 3 Top Deal'),'No13Deals',

if(Match(Deals,'No. 5 Top Deal','No. 4 Top Deal'),'No54Deals',

if(Match(Deals,'No. 2 Top Deal'), 'No2Deals'))) as NewDeals

and in SortExpression you can use

Pick(Wildmatch(NewDeals,'No13Deals','No54Deals','No2Deals'),1,2,3)

Re: Inline sort

shraddha_g — Thu, 16 Nov 2017 12:08:36 GMT

Else you can also uncheck all Sort option. It will use Load order. And by default it will give you the order in which you have created it

Re: Inline sort

its_anandrjs — Thu, 16 Nov 2017 12:11:18 GMT

In Sort expression try this with Only

=Only( {1}

if(Match(Deals,'No. 1 Top Deal','No. 3 Top Deal'),'No13Deals',

if(Match(Deals,'No. 5 Top Deal','No. 4 Top Deal'),'No54Deals',

if(Match(Deals,'No. 2 Top Deal'), 'No2Deals')))

)

Re: Inline sort

sunny_talwar — Thu, 16 Nov 2017 12:15:21 GMT

You can load an inline table right at the beginning of your script

Temp:

LOAD * Inline [

Deals, DealGrouping

No. 1 Top Deal, No13Deals

No. 3 Top Deal, No13Deals

No. 5 Top Deal, No54Deals

No. 4 Top Deal, No54Deals

No. 2 Top Deal, No2Deals

];

Now use DealGrouping as your dimension and sort by load order