Hello all,
I have created a regular table in QlikSense and in the table I have added a column which contains small bars that are supposed to represent quarters.
The formula is as follows:
concat(aggr(
pick(ceil(sum($(=(vVariable)))/max(total aggr(sum($(=(vVariable))), Quarter, $(=(vDimension))))*6),'_','▂','▃','▅','▆','▇')
, $(=(vDimension)), Quarter),'',Quarter)
With this I get the column in question updated with bars that correspond to each quarter since the beginning of the data that I have. I would like to make it so that the column will be showing only the latest 5 bars (the last 5 quarters) instead of all of them.
Any ideas on how to achieve this?
Best Regards,
Shelly