topic Re: Possible values selection in QlikView

Possible values selection

sachinryeola — Sat, 03 Jan 2015 08:30:49 GMT

HI Guys,

Below is the sample table.

Query:

there will be two tables Entry No an FS Line.

I want the possible values straight table for FS line.

Ex.

If I select A from FS LIne there will be associated values selection in Entry No list box,

Now i want to create a straight table where a column will show other FS lines which are related to those entry nos in ENtry No listbox.

IF i select A in FS Line i will get 1,2,4,5 in Entry No

Now i want to create straight table where i will get FS lines related to 1,2,4,5

Plz suggest ASAP

Regards,

Sachin

Anonymous — Sat, 03 Jan 2015 16:58:53 GMT

Hello!

Can you see my attachment?

I used alternate states with Field Event Trigger (OnSelect) for FS Line

Let me know if it can be usefull.

Elena

rwunderlich — Sat, 03 Jan 2015 21:26:17 GMT

You can do this with the set expression

{<[Entry NO]=p(), [FS Line]=>}

You can either put the set in the chart expression(s) like:

=sum( {<[Entry NO]=p(), [FS Line]=>} Value)

or perhaps easier, create your [FS Line] chart dim as a calculated dimension like this:

=aggr(only({<[Entry NO]=p(), [FS Line]=>}[FS Line]),[FS Line])

-Rob