Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Partner
Partner

Pivot tab not giving correct results when dimension added as Column

Hi,

I have a pivot table which is behaving weird in providing the results:

Below are the 2 formats:

QuantityMonth-201908
Capacity7407999

 

Quantity, Month-201908 
Capacity1852000


In the first table, i have added Quantity as Row and Month as Column. Quantity is an inline dimension which contains Capacity as one of its records to which the KPI is linked ( if Quantity ='Capacity', sum(Capacity)) whose value is actually 1852000  for Month 201908 but it is showing correctly only when i keep both dimensions Quantity and Month in the Row. 

As though, it gets like expanded view from Quantity to Month level.

Not sure , the value 7407999 is coming from where but I want to add Quantity in Row and Month in the Column..

Can some one please tell me whats going wrong here ?

Tags (2)