topic Re: Avoidance in list box in QlikView

Avoidance in list box

Anonymous — Fri, 10 Apr 2015 19:09:46 GMT

Hi All

In list box, how it is possible ignore selection.

Like in below Set Analysis SNAME slection are ignored.

sum({$<SNAME=>} VALUE)

Is this possible in list box? Like show all SNAME

Thanks

Re: Avoidance in list box

petter — Fri, 10 Apr 2015 19:13:27 GMT

Create an "Alternate State" in your Document and then select the newly created alternate state as the state for your list box. Then this list box will not be selection-wise be connected to your default selection state.

Re: Avoidance in list box

Anonymous — Fri, 10 Apr 2015 20:18:30 GMT

Hi Petter

By this even if I select any SNAME which does not affect to my Pivot table.

I should need this effect based on SNAME selection

Thanks for your suggestion

Re: Avoidance in list box

petter — Fri, 10 Apr 2015 20:30:00 GMT

Then you can refer explicitly to the selection in the Alternate State like this:

Sum( {AltState1} Sales)

This makes the Sales be affected by only AltState1 but you can refine it with set modifiers or even combine it with selection in the default state which has the name $ ... just as the default selection also has the name $:

Sales( {AltState1<SNAME={'ABC'}>} Sales)

Sales( {AltState1<SNAME={'ABC'}*$<Product={'B123'}>} Sales)

This will intersect with the * between the rows in AltState1 and Default State taking into account the modifiers too.