topic Displaying charts based on list box selection in QlikView

Displaying charts based on list box selection

parul_mehta — Mon, 22 May 2017 15:09:23 GMT

Hi,

I have a requirement wherein I need to display charts based on values selected in list box

List box material has 9 values

I select A, Chart A should display the required data , charts B, C and D should dsplay nothing

AB , Both charts A and B should get activated and display required data , charts C and D should dsplay nothing

ABC Charts A, B and C should get activated and display required data, charts D should dsplay nothing

ABCD , Charts A B C d should get activated, and display the required data

Maximum of 4 values can be selected in Listbox, and corresponding charts to display data

Material	Chart A	Chart C
A
B
C
D
E
F	Chart B	Chart D
G
H
I

Re: Displaying charts based on list box selection

Anonymous — Mon, 22 May 2017 16:08:37 GMT

Use a calculation condition.

For chart

=wildmatch(GetFieldSelections(Material),'*A*') and GetSelectedCount(Material)<>0

Change A to for each chart value.

Re: Displaying charts based on list box selection

Frank_Hartmann — Mon, 22 May 2017 16:33:06 GMT

attached sample might be helpful

Re: Displaying charts based on list box selection

Sergey_Shuklin — Mon, 22 May 2017 17:27:36 GMT

Hello, Parul!

You can use a FindOneOf() and GetFieldSelections() functions to solve that task.

Please, find an attachement below. Hope it's what you lookin' for!

Re: Displaying charts based on list box selection

Anonymous — Mon, 22 May 2017 17:41:07 GMT

Putting in expression didn't even occur to me. Nice implementation.

I do suspect the calculation condition would perform a little bit better. Plus it keeps your expression(s) cleaner.

And I think you would really only need =wildmatch(GetFieldSelections(Material),'*A*') (not what i had earlier).

The other bonus with calculation condition is that then you can go into the Error Messages and customize the message to say whatever you want. Like "Chart will populate when selected in filter".

Re: Displaying charts based on list box selection

parul_mehta — Tue, 23 May 2017 04:17:15 GMT

Thanks for the example qvw.,

I have around 80000 materials, and would like to display any of the 4 field selections in the chart, not hardcoded values

the first value selected ( could be at the 24th row ) should be displayed in chart A

second value selected ( could be elsewhere , say the 50th value ) that should display in chart B

third value selected ( at any row ) should display in chart C

fourth value selected, ( say at row 108 ) should display in chart D

if you could please help with this.

Re: Displaying charts based on list box selection

parul_mehta — Tue, 23 May 2017 13:41:26 GMT

Please provide inputs