Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

greend21
Contributor II

Calculated Dimension or Set Analysis?

I've created a pivot table that shows department, month, and year dimensions and has three expressions for the totals columns. I want the chart to only show 3 months of data, with this always being the most recent three months of data.

Can this be done with a calculated dimension rather than set analyis? I think I would need to add a set expresssion to ALL three expressions right? I'd rather avoid that if possible due to formatting in the expression to make it show as hh:mm:ss.

Any tips are appreciated!

5 Replies

Re: Calculated Dimension or Set Analysis?

You can do it if MonthYear or Date is your dimenion

greend21
Contributor II

Re: Calculated Dimension or Set Analysis?

Can you provide an example how? I was trying and kept getting "error in calculation." Month and year are both dimensions in this particular chart. I have specific dates available in my data too.

Re: Calculated Dimension or Set Analysis?

May be like this

If(MonthYear >= Max(TOTAL MonthYear, 3), MonthYear)

and then check 'Suppress When Value is Null'.

greend21
Contributor II

Re: Calculated Dimension or Set Analysis?

This provides only null values

Re: Calculated Dimension or Set Analysis?

Won't know until I see what you have

Community Browser