Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Calculation of active and inactive values in pivot table

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

5 Replies
Not applicable

Re: Calculation of active and inactive values in pivot table

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

Not applicable

Re: Calculation of active and inactive values in pivot table

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

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

regards-Bika

Not applicable

Re: Calculation of active and inactive values in pivot table

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.

image.pngHi,

preminqlik
Valued Contributor II

Re: Calculation of active and inactive values in pivot table

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]

Not applicable

Re: Calculation of active and inactive values in pivot table

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

Community Browser