Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sachinryeola
Contributor II
Contributor II

Possible values selection

  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.

Entry NO

FS Line

1A
2B
3C
4A
5B
1C
2A
3B
4C
5A

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

2 Replies
Anonymous
Not applicable

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

http://masterssummit.com

http://robwunderlich.com