topic Re: alternate states in QlikView

alternate states

rittermd — Sat, 31 Jan 2015 23:05:48 GMT

This is what I want to do and I am not sure if it is possible using Alternate states or any other way.

I have two charts and one straight table in my dashboard.

I have a filter that I only want to work with the table. But I need the table to work with the other filters and the charts.

I tried setting alternate states and I can make the table work with the filter. But then it doesn't respond to any other changes.

I guess my question is can an object have multiple states or is there another way to do this?

Re: alternate states

robert_mika — Sat, 31 Jan 2015 23:15:54 GMT

Look here:

http://community.qlik.com/message/410525#410525

Re: alternate states

Sat, 31 Jan 2015 23:24:40 GMT

Instead of using alternate states in this case, I would use set analysis on the charts, so that they won't be affected by the selections on the filter.

Let's say that your filter is called 'Country'.

Then on each of the charts I would add "Country=" in the set analysis.

Example: sum({<Country=>}Sales)

This way the charts will respond to everything except your filter and table will still be affected by the filter (and the rest of the other selections).

Hope this helps.

Kind regards,

Nuno

Re: alternate states

sujeetsingh — Sat, 31 Jan 2015 23:26:32 GMT

I do not think that alternate state can achieve this.

So the logic is to use set analysis to disable a field or filter selection on an object

Let there be 3 filters

Brand,Location,Store

Now you want Brand and location to be selectable for the for the all three objects but Store not for the straight table.

So let straight table have expression sum(Sales)

then write it as

=sum({<Store=->} Sales)