topic Simple Sort expression correction needed in QlikView

Simple Sort expression correction needed

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

Hi Experts,

Can any one please help me on this.

I have a deals dimensions containing below records.

By if match condition I have created 3 records by using the below expression.

=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')))

But getting sort order like

No13Deals,

No2Deals

No54Deals,

Expected Sort order:

No13Deals,

No54Deals,

No2Deals

I have tried the below sort expression but getting error in expression. Please correct the expression with this logic only.

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

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

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

Thanks in advance.

Please find the attached app.

Anil_Babu_Samineni — Thu, 16 Nov 2017 04:46:40 GMT

Try this?

=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))))

its_anandrjs — Thu, 16 Nov 2017 04:48:51 GMT

One of this also

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

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

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

its_anandrjs — Thu, 16 Nov 2017 04:49:24 GMT

Or may this

=Only( {1} 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)))) )

devarasu07 — Thu, 16 Nov 2017 04:53:50 GMT

Hi,

best way just use the Dual function,

=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))))