topic Re: How to show it in pivot table in QlikView

How to show it in pivot table

Tue, 14 Jul 2015 07:27:13 GMT

HI All,

I have the following table:

load * Inline

[YearMonth, Revenue, TimeId,ShowTimeId

2015-7-1,100,400,399

2015-7-1,200,401,402

];

I want to use one pivot table to show the data as following:

Dimension: YearMonth, Custom Dimension(if the ShowTimeID< the min of the TimeId then "Case1" else Case2)

The min of the TimeId for this case is 400

Metric: sum(Revenue)

How can I do that?

Thanks.

qlikmsg4u — Tue, 14 Jul 2015 07:32:54 GMT

Hi Issac,

Use this in Calculated Dimension

=IF(ShowTimeId < Aggr(Min(TimeId),TimeId),'Case1','Case2')

settu_periasamy — Tue, 14 Jul 2015 07:34:40 GMT

PFA

Tue, 14 Jul 2015 07:43:14 GMT

Hi,

PFA.

Hope it helps.