Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

ignoring all filters on a specific table within a worsheet

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

8 Replies
vishsaggi
Champion III
Champion III

Use Alternate States. Alternate States ‒ QlikView

Anonymous
Not applicable
Author

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

vishsaggi
Champion III
Champion III

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.

Anonymous
Not applicable
Author

I'll take a look, thanks

karthikoffi27se
Creator III
Creator III

Hi Andy,

You can use set analysis like below

Sum{<Year=,Month=,Yourfield={"value'}>}value)

This will work

Many Thanks

Karthik

abhijith862
Contributor III
Contributor III

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

http://branch.qlik.com/#!/project/569368a0fe261eb8649bf582

PrashantSangle

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
shiveshsingh
Master
Master

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=,>