Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
RodrigoAsa
Contributor
Contributor

Ignore selected filters and keep the one from Set Analisys

Dear all, good morning.

I have a problem: I need it to maintain the date filter I set in the analisys set. In this case, it would be the last three months (in this case, August, September, and October, since it's October), but it's only showing the current month. So, I'd like to know possible solutions to this problem.

Thank you all in advance.
Labels (2)
3 Replies
robert_mika
Master III
Master III

Maybe lie that?

Sum({$<  Product=,Customer=,Year={2009}>} Sales)

The part in your post is different?

What is the issue

RodrigoAsa
Contributor
Contributor
Author

In this part of my analysis set: [Data de Emissão] = {">=$(vMêsAtual2Retro)<=$(vFimMêsAtual)"},
The variable 'vMêsAtual2Retro' is used to get the two retroactive months and 'vFimMêsAtual' shows the current month. The objective is to get the revenue for the current month and the two retroactive ones.

Vegar
MVP
MVP

I assume you are making selections to other date/month fields than  [Data de Emissão] . As @robert_mika  suggests, you might need to clear those selections. Let's assume you select October in a [Month] fields. Then try this:

SUM({<Month, [Data de Emissão] = {">=$(vMêsAtual2Retro)<=$(vFimMêsAtual)"} >} [Amount])