topic Re: Calculated Dimension or Set Analysis? in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398864#M513390 <HTML><HEAD></HEAD><BODY><P>Won't know until I see what you have <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 15 Nov 2017 20:20:38 GMT sunny_talwar 2017-11-15T20:20:38Z Calculated Dimension or Set Analysis? https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398859#M513385 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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.</P><P></P><P>Any tips are appreciated!</P></BODY></HTML> Wed, 15 Nov 2017 19:34:01 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398859#M513385 greend21 2017-11-15T19:34:01Z Re: Calculated Dimension or Set Analysis? https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398860#M513386 <HTML><HEAD></HEAD><BODY><P>You can do it if MonthYear or Date is your dimenion</P></BODY></HTML> Wed, 15 Nov 2017 19:43:23 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398860#M513386 sunny_talwar 2017-11-15T19:43:23Z Re: Calculated Dimension or Set Analysis? https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398861#M513387 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 15 Nov 2017 19:45:52 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398861#M513387 greend21 2017-11-15T19:45:52Z Re: Calculated Dimension or Set Analysis? https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398862#M513388 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>If(MonthYear &gt;= Max(TOTAL MonthYear, 3), MonthYear)</STRONG></P><P></P><P>and then check 'Suppress When Value is Null'.</P></BODY></HTML> Wed, 15 Nov 2017 19:50:47 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398862#M513388 sunny_talwar 2017-11-15T19:50:47Z Re: Calculated Dimension or Set Analysis? https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398863#M513389 <HTML><HEAD></HEAD><BODY><P>This provides only null values</P></BODY></HTML> Wed, 15 Nov 2017 20:16:00 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398863#M513389 greend21 2017-11-15T20:16:00Z Re: Calculated Dimension or Set Analysis? https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398864#M513390 <HTML><HEAD></HEAD><BODY><P>Won't know until I see what you have <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 15 Nov 2017 20:20:38 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-or-Set-Analysis/m-p/1398864#M513390 sunny_talwar 2017-11-15T20:20:38Z