topic Re: how to reflect the chart based on list box selection? in QlikView

how to reflect the chart based on list box selection?

gkcchowdary — Wed, 25 Nov 2020 16:16:04 GMT

I have 10 filters and i am creating one bar chart and one straight table.

my requirement is if i select 5 filters it display bar and if i select 10 filters(fields)it display bar chart.

ex if i select fields= a1,a2,a3,a4,a5 it display straight table.

if i select fields= a1,a2,a3,a4,a5,b1,b2,b3,b4,b5 it display bar chart.

Thanks

Anil_Babu_Samineni — Sat, 03 Feb 2018 09:21:54 GMT

This is possible, Can you make it sample application instead talking the requirement

gkcchowdary — Sat, 03 Feb 2018 10:39:46 GMT

This is just interview question.if you know the answer write it otherwise leave it.

Anil_Babu_Samineni — Sat, 03 Feb 2018 10:48:03 GMT

Even, Interview time also i can ask same question to Interviewer.. I know the answer, Perhaps this?

Create this measure from layout tab under condition enable like

If(Match(FieldName, 'a1','a2','a3','a4','a5'), 1,0) -- For Straight Table

If(Match(FieldName, 'a1','a2','a3','a4','a5','b1','b2','b3','b4','b5'), 1,0) -- For Bar Graph

shiveshsingh — Sat, 03 Feb 2018 11:21:20 GMT

You need to write condition in layout tab for visibility of both the charts.

gkcchowdary — Sat, 03 Feb 2018 11:25:51 GMT

thanks for your reply and i will try with above expressions.

vishsaggi — Sat, 03 Feb 2018 14:15:23 GMT

Are your A and B our field names or your field values?