Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to show excluded months for any ID selected.
Like for below example I want to show period 2018012 to 201905 in the bar chart.
Kindly help.
@sunny_talwar @swuehl @tresesco @Gysbert_Wassenaar
Thanks
What exactly are you not understanding?
Sum(Revenue)
+
Sum({1<Week = $::Week, Month = $::Month>} 0)
This?
Thanks Sunny for your solution. May be I have not framed my doubt clearly.
I found the solution from your reply on
Could you explain the expression that you used in above link?
What exactly do you not understand from the app in the other post?
The expression in bar chart for revenue.
What exactly are you not understanding?
Sum(Revenue)
+
Sum({1<Week = $::Week, Month = $::Month>} 0)
Just adding a couple of Design Blog URLs to posts that may help in explaining things...
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704
Hopefully these may fill in the gaps you have, be sure to give Sunny credit for the help by using the Accept as Solution button on the post that got you what you needed, or mark the post with the link to his prior post...
Regards,
Brett