Qliksense pivot table problem

[wangxusq]

Hi everybody,

I created a pivot table in qliksense. the picture is :

Now Red represents the first dimension. Blue represents the second dimension.But the second value maybe has null value.

So I want to hide rows like '-'.  But if I do not set the second dimension  to include nullvalue.then the first dimension value will be  missing.

That's not my requoirements.

My requirement is :

When the first dimension and second dimension both have value ,then both display, but when the first dimension has value and

second dimension has no value, then hide the second dimension rows like '-',just stay the first dimension value.

Any idea? Thanks

[devarasu07]

HI,

In your pivot table Suppress null value option for your 2nd dimension. it should work.

like below

In your 2nd dimension write expression like below,

=If(Len(Trim(Dime2))>0,Dime2)  and make sure to Un tick the "Include Null value option" at dim2

Thanks

Deva

[wangxusq]

Thanks ,I have solved it.