Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

Ignore Selection Filter DAY

good morning
I need help! I am making a bar graph where I show the sales of the previous month vs current month, when I filter by Year or Month it shows me the sales of a previous month. But the problem I have is that when I select the day, my graph does not show me the sales of the previous month, only the current sales and the day I filter. Then they ask me that when I filter the day that the sales of the previous month are still showing, the sales of the previous month are for the last day of the month just like the current one. I am applying the following formula:

(SUM ({$ <CLOSURE_ MONTH = {1}, DATE = {"$ (= Max ({<MONTH = {'$ (= Month (AddMonths (Max (DATE), - 1))))'}, YEAR = { '$ (= Year (AddMonths (Max (DATE), - 1)))'}>} DATE)) "}, MONTH =, DAY =>} SALES))
* (-1)

So in the formula I am saying that I ignore the selections of the DIA field, I do not know that I need to add in the set and analysis or do something else so that I can perform that visualization or it cannot be done.
I add some images of how the graph is and when I select the day as shown.

I hope you can help me, since I don't know how to do it
Thank you so much

Labels (1)
2 Replies
allorens_14
New Contributor II

Re: Ignore Selection Filter DAY

Have you tried to remove the '$' identifier  in the beginning of the set analysis?  It associate your selection with the set analysis.

Partner
Partner

Re: Ignore Selection Filter DAY

Thank you very much for your time Alloren_14
if I already remove the $, but it still does not show me the bars of the previous month when selecting the day. I don't know how another way can be done