Show excluded months in bar chart

[kinjal1645]

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

[sunny_talwar]

This?

[kinjal1645]

Thanks Sunny for your solution. May be I have not framed my doubt clearly.

I found the solution from your reply on 

https://community.qlik.com/t5/New-to-QlikView/Missing-dates-in-a-bar-chart/m-p/1407172/highlight/tru...

Could you explain the expression that you used in above link?

[sunny_talwar]

What exactly do you not understand from the app in the other post?

[kinjal1645]

The expression in bar chart for revenue.

[sunny_talwar · Accepted solution]

What exactly are you not understanding?

Sum(Revenue)
+
Sum({1<Week = $::Week, Month = $::Month>} 0)

[Brett_Bleess]

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