topic Trend lines based on selection fields in QlikView

Trend lines based on selection fields

raju_salmon — Tue, 14 Jun 2016 12:33:36 GMT

Hi,

I have a trend line with Count(Customer) for all Stores.

My dimension is Year and expression is Count(Customer).

Now my trend line shows only one for all stores.

When i select more than one store from store list box, i need to get trend lines based on selection count.

For example, i have selected 3 stores in my list box and chart should show three line, can we show that?

Please help me on this.

Thanks,

Raju

raju_salmon — Tue, 14 Jun 2016 12:48:13 GMT

Can we use Stores as second dimension and can put any condition to display?

I am trying with below condition at dimension (enable condition) but not working.

=if(GetSelectedCount(Stores)<>0, Stores)

sunny_talwar — Tue, 14 Jun 2016 12:52:57 GMT

Not entirely sure, but may be add store as your second dimension

Anonymous — Tue, 14 Jun 2016 12:55:07 GMT

try to define a second Dimension as calculated dimension

=if(GetSelectedCount(Stores)<>0, Stores)

if you select 1,2 or 3 stores you should see 1,2, or 3 lines

using enabele condition will Show lines or no lines depending on condition and is not what you need

swuehl — Tue, 14 Jun 2016 12:59:05 GMT

Try this as enable conditional for the second dimension

=GetSelectedCount(Stores) > 1

to enable the dimension Stores when more than 1 store is selected (and use Stores as dimension to enable).

But this may not only show multiple trendlines, but also multiple bars / lines etc. for your different stores.