Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Show excluded months in bar chart

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.

Capture.PNG

Kindly help.

@sunny_talwar @swuehl @tresesco @Gysbert_Wassenaar 

 

Thanks

Labels (2)
1 Solution

Accepted Solutions
Highlighted

What exactly are you not understanding?

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

View solution in original post

6 Replies
Highlighted

This?

image.png

Highlighted
Creator
Creator

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?

Highlighted

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

Highlighted
Creator
Creator

The expression in bar chart for revenue.

Highlighted

What exactly are you not understanding?

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

View solution in original post

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.