Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a specific table with multiple dimensions and measures within a worksheet. I want the entire table to ignore the Month and year filters. Is there a way to do this without having to use set analysis on each field?
thanks in advance
Use Alternate States. Alternate States ‒ QlikView
is this an extension I need to install? I use Qlik sense and can't find anything bout Alternate states using the search menu
Also a little help on how to install Alternate states would be appreciated
thanks in advance
Not sure in Qliksense may be you have to install an extension. Read below article which will guide you. There is a link inside this article to use Alt State with extension.
Using Alternate State in QLikSense (without Extensions)
Let me know if you succeed.
I'll take a look, thanks
Hi Andy,
You can use set analysis like below
Sum{<Year=,Month=,Yourfield={"value'}>}value)
This will work
Many Thanks
Karthik
Hi, You will have to use Alternate State in Sense and as it is not available in Sense by Default you will have to use an extension for the same. I have used this and is quite simple to implement
Hi,
Use logic suggested by karthikoffi27sep i.e. nullify those field.
or write use 1 to avoid selection
like
Sum{1<Yourfield={"value'}>}value)
Regards,
In qlikview, you need AS(Alternate States) but in qliksense, i think it is not from default.
If you need to ignore year and month in expression in you chart, you can simply bypass them in set analysis
<Year=,Month=,>