Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
if i understood correctly
in dimension
=if(date<=Date(AddMonths(today(),-6), 'YYYY-MMM'),date)
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]))
wher u have entererd this expression