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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
tungogers_mbps
Contributor
Contributor

Specific Month on a Bar Chart

I'm doing a bar chart with dates from Jan 2019 upto Dec 2021.

How can I start the bar chart from Oct 2020 upto Dec 2021?

 

Thanks!

3 Replies
Anil_Babu_Samineni

If there is no logic to start from Oct 2020, You can simply do as dimension

If(MonthName>='Oct 2020' and MonthName<='Dec 2020', MonthName)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
tungogers_mbps
Contributor
Contributor
Author

Can we do it not hard coded in a set analysis>

Anil_Babu_Samineni

That is what my concern, please explain how you need dynamic for that. IF you still need only as static in set analysis, Try this

Sum([<MonthName={">='Oct 2020'<='Dec 2020'"}>} Measure)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful