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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Harley
Contributor II
Contributor II

Bar Chart shows current and previous 6 months data

Hi,

i'm using Qlik Sense and i am new to this. 

i need help on how to display current and previous 6 months data on the bar chart. I have 3 years data in total. 

Kindly help me on how to display the data in details. Please show me step by step. 

X-axis is Submission Date (YearMonth)

Y-axis Count(change request)Capture.PNG

3 Replies
Taoufiq_Zarra
MVP
MVP

if i understood correctly

in dimension

 

=if(date<=Date(AddMonths(today(),-6), 'YYYY-MMM'),date)

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Harley
Contributor II
Contributor II
Author

Thank for your reply. 

it worked but it's shows date dd/mm/yy.

below is my solution 

=if(MonthName([datefield]) >= addmonths(today(),-12) and MonthName([datefield]) <= addmonths(today(),+6), MonthName([datefield]))

Arindam_Ghoshal_13
Contributor III
Contributor III

wher u have entererd this expression