topic Re: Last 5 rows in Pivot Table in QlikView

Last 5 rows in Pivot Table

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a pivot table which is showing value by Quarter.

I want to show last 5 quarter.

My Expression is like below for dimension:

=If(CstFiscalYearQuarterConcat>= Max( TOTAL CstFiscalYearQuarterConcat,5), CstFiscalYearQuarterConcat).

It is showing perfect.

Now user want see Quarter as Year-Quarter. And it would be :

CstFiscalYear & '-' & CstFiscalQuarterNum

These concated field is not working in the above syntax. I feel this is not a number, that might be the reason.

Could anyone please help me out.

Thanks,

Sarif

afsarshaikh — Fri, 08 Sep 2017 11:14:57 GMT

Hope this works:

Concat(distinct CstFiscalYear ,'-',CstFiscalQuarterNum)

Kushal_Chawda — Fri, 08 Sep 2017 11:28:18 GMT

create the numeric quarter value using DUAL function like below in script

=dual(CstFiscalYear & '-' & CstFiscalQuarterNum,CstFiscalYear&CstFiscalQuarterNum) as CstFiscalYearQuarterConcat

Now you can use condition

=If(CstFiscalYearQuarterConcat>= Max( TOTAL CstFiscalYearQuarterConcat,5), CstFiscalYearQuarterConcat)

=If(CstFiscalYearQuarterConcat<= Max( TOTAL CstFiscalYearQuarterConcat,5), CstFiscalYearQuarterConcat).