Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
sachinryeola
New 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

Tags (2)
2 Replies
elena888
Valued Contributor

Re: Possible values selection

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

MVP & Luminary
MVP & Luminary

Re: Possible values selection

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