Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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

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