Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Anonymous
Not applicable

Always show last 12 month (Bar chart)

Hello,

I want to build a bar chart which always show the last 12 months (based in max(date)).

My real doubt is when i change the maxDate, the sort stay out of order. Even if i set a expression in sort tab:

Date#(date,'MMM-YYYY')

It stay in order without filter of data, filtering previous month, stay out of order. How to solve it?

Thanks

1 Reply
MVP
MVP

Re: Always show last 12 month (Bar chart)

hope to understand

you have a bar chart with month - year on x axis

maybe a calculated dimension =year(Date) & '-' & Month(Date)

try with sort by expression

max(Date)