Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

Not applicable
Author

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
Author

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
Specialist II
Specialist II

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
Author

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