topic Re: Calculation of active and inactive values in pivot table in QlikView

Calculation of active and inactive values in pivot table

Thu, 27 Jun 2013 12:56:49 GMT

Hello all,

I am new to qlikview

I was working on a report where I have to show count of non-zero values as active and zero values as inactive in pivot table.

when dealing with multiple dimensions , if they are in rows then the values calculated in script works as in chart I

But when I transpose one dimension to column , then this fails as in chart II

I have attached the qvw file for reference ....

Plase help me out in this case.

Thanks for considerations and support

Re: Calculation of active and inactive values in pivot table

Fri, 28 Jun 2013 04:51:46 GMT

ANY HELP FROM ANY BODY!!!!!!!!!!!!!!!!!!!!!!!

Re: Calculation of active and inactive values in pivot table

Fri, 28 Jun 2013 05:05:47 GMT

there are 4 different table in ur application..there is no link ..

try to make one table or try to link table..

regards-Bika

Re: Calculation of active and inactive values in pivot table

Fri, 28 Jun 2013 05:51:54 GMT

Thanks for showing concern,

Actualy my concern is only as following,

suppose as in below image there one raw table , of which I have to create a pivot table having one or more dimension in rows and one or more dimensions in columns.

Then the Active and Inactive values should be calculated as per non zero and zero values available in pivot table.

Hope I am able to explain my problem.

Hi,

Re: Calculation of active and inactive values in pivot table

preminqlik — Fri, 28 Jun 2013 09:25:40 GMT

Add this expression oin this script

If(Count(fieldname)<0 or Count(fieldname)>0,'Active','Inactive') as Status(fieldname2)

[always make sure that test any fieldvalue or fieldname in text box]

Re: Calculation of active and inactive values in pivot table

Fri, 28 Jun 2013 11:34:24 GMT

Thanks but I cannot get values as per my output chart....