topic Re: Show higher class in QlikView

Show higher class

hamzabob1 — Wed, 08 Jul 2015 10:04:52 GMT

Hii all,

I am new here and i have one question.

Invoice	Class	Required Output
1563489	First class Business class	First class
1543632	First class Economy class	First class
1673492	Business class Economy class	Business class

In the above example i have invoice_id and class.In some cases i have 2 class for one invoice id but i have to display only one class which has higher priority as i mention in required output field.please help me its urgent.

Thanks in advance

Re: Show higher class

swuehl — Wed, 08 Jul 2015 15:28:00 GMT

I would start with defining the priority in the script:

LOAD Class, recno() as Priority INLINE [

Class

First class

Business class

Economy class

];

Then you should get what you want, e.g by using a chart with dimension Invoice and as expression

=FirstSortedValue( Class, -Priority)

Re: Show higher class

hamzabob1 — Thu, 09 Jul 2015 04:15:51 GMT

Thanks for your rpl..

but this is not wat i am looking for...

Re: Show higher class

Anonymous — Thu, 09 Jul 2015 05:09:01 GMT

PFA

Re: Show higher class

maxgro — Thu, 09 Jul 2015 05:17:13 GMT

using Priority as previous suggestion

subfield(concat(Class, '@', Priority), '@', 1)

load * inline [

Invoice, Class, Required Output

1563489, First class, First class

1563489, Business class, First class

1543632, First class, First class

1543632, Economy class, First class

1673492, Business class, Business class

1673492, Economy class, Business class

];

LOAD Class, recno() as Priority INLINE [

Class

First class

Business class

Economy class

];

Re: Show higher class

Thu, 09 Jul 2015 05:25:52 GMT

Hi,

Please find the attached QVW file.

Re: Show higher class

hamzabob1 — Thu, 09 Jul 2015 05:47:31 GMT

Wow, super thanks to all.

Thanks