Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
elena888
Specialist
Specialist

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
MVP & Luminary
MVP & Luminary

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