topic Re: Chart show default values, but change by selection in QlikView

Chart show default values, but change by selection

kfir1987 — Tue, 31 Jul 2018 07:53:28 GMT

Hi,

I am trying to create a chart with default presentation, but on selection the chart will change to view as pair as the selection.

My dimension is Time (Year-Quarter) and Material and the measure is sum of usage. In general, the chart should show usage per material over the time.

So I want to show by default the materials: X,Y and Z. But when the user select the material A all the default selection will disappear and only matiral A will be show.

Of course when the user clear his selection, the chart will show again the default selection .

Thank you

Re: Chart show default values, but change by selection

sibin_jacob — Tue, 31 Jul 2018 08:04:16 GMT

Can you explain little more.

How you are showing the materials: X,Y and Z by default?

Can you please share your expression and dimension?

if you want to exclude the material selection, you need to use material = in the set analysis.

Re: Chart show default values, but change by selection

kfir1987 — Tue, 31 Jul 2018 08:15:16 GMT

regarding your question "How you are showing the materials: X,Y and Z by default?" - This is my question

my expression for Sum([Usage])

Re: Chart show default values, but change by selection

sibin_jacob — Tue, 31 Jul 2018 08:22:41 GMT

Okay,

Please use the below formula for materials Dimension, and check " suppress when value is NULL"

=if(GetSelectedCount(materials)=0,

if(match(materials,'X','Y','Z'),materials),

materials)