topic Re: Using 2nd selected value as a Dim in Alternate State in QlikView

Using 2nd selected value as a Dim in Alternate State

Anonymous — Tue, 05 May 2015 22:01:18 GMT

Hello everyone!

Is it possible to use only 2nd, 3rd, 4th from the top of selected values in listbox?

For example: I'd like to use 2nd or 3rd value from the top of selected values in listbox and use it as a dimension in table with Alternate State.

Re: Using 2nd selected value as Alternate State

tresB — Wed, 06 May 2015 06:13:11 GMT

One way to get

2nd value - Subfield(Concat(Distinct YourField, ';'), ';', 2)
3rd value - Subfield(Concat(Distinct YourField, ';'), ';', 3)

Note, here sorting of the field values/load order would play an important role to decide which value comes first but the order of selection.

Re: Using 2nd selected value as a Dim in Alternate State

Anonymous — Wed, 06 May 2015 06:14:19 GMT

I know But how can I use it as a dimension?

Re: Using 2nd selected value as a Dim in Alternate State

tresB — Wed, 06 May 2015 06:17:35 GMT

Could you please share a sample qvw explaining the requirement a bit more in detail?

Re: Using 2nd selected value as a Dim in Alternate State

vincent_ardiet — Wed, 06 May 2015 06:37:01 GMT

Hi,

You can try to use a IF in your dimension which can be poor in performance but it depends on the size of your application.

For example with something like this in the dimension expression and a dimension limit to have only 2 values displayed:

=if(match(NAME,$(=mid(concat({$}distinct NAME,chr(39)&','&chr(39)),index(concat({$}distinct NAME,chr(39)&','&chr(39)),chr(39)&','&chr(39))+2)&chr(39))),NAME)

Re: Using 2nd selected value as a Dim in Alternate State

Anonymous — Wed, 06 May 2015 06:42:32 GMT

Re: Using 2nd selected value as a Dim in Alternate State

jagan — Wed, 06 May 2015 06:46:56 GMT

Hi,

Try like this

Dimension: YourField

Expression: Sum({<YourField={"$(=Subfield(Concat(Distinct YourField, ';'), ';', 2))", "$(=Subfield(Concat(Distinct YourField, ';'), ';', 3))" }>} Measure)

Hope this helps you.

Regards,

Jagan.

Re: Using 2nd selected value as a Dim in Alternate State

jagan — Wed, 06 May 2015 06:48:46 GMT

Please find attached file for solution.

Regards,

Jagan.

Re: Using 2nd selected value as a Dim in Alternate State

Anonymous — Wed, 06 May 2015 06:57:39 GMT

Dimension: YourField

Expression: Sum({<YourField={"$(=Subfield(Concat(Distinct YourField, ';'), ';', 2))","$(=Subfield(Concat(Distinct YourField, ';'), ';', 3))" }>} Measure)

That helped. Thank you