topic Re: How to delete empty cell in straight table in expression tab in QlikView

How to delete empty cell in straight table in expression tab

ramrongala — Wed, 25 Nov 2020 16:16:04 GMT

Please help on this scenario in higher priority.

This my straight table

My requirement: i want separate the positive negative zero and no data for suppose negative values like below

=if([sep]-[apr]<0,[sep]-[apr]) i used this expression so below output wiil come.

I want see only negative values in based on expression(difference) that mean delete or hide reaming data.

i want see only 4 negative values(-0.18,-1.18,-1.00,-2.67) reaming data (spaces) i don't want see that mean hide or delete those rows.

Gysbert_Wassenaar — Wed, 23 Nov 2016 18:36:10 GMT

Add the same condition to the other expressions: =if([sep]-[apr]<0, ...apr expression... )

rupamjyotidas — Wed, 23 Nov 2016 19:07:39 GMT

In Calculated Dimension Maybe

if([sep]-[apr]<0, YourDimension)

veeranj — Thu, 24 Nov 2016 08:30:52 GMT

Hi,

add this in calculation dimension

=if(

(aggr(sum({$<Month={'September'}>}[Passing Fraction])/Count({$<Month={'September'}>}[Passing Fraction]),[Attribute Name]))

(aggr(sum({$<Month={'April'}>}[Passing Fraction])/Count({$<Month={'April'}>}[Passing Fraction]),[Attribute Name])),1,null())

and check option "suppress when value is null" .

Thanks,

Anjee

ramrongala — Thu, 24 Nov 2016 10:01:55 GMT

It's working finally...Thanks to every one

ramrongala — Thu, 24 Nov 2016 10:02:58 GMT

Thanks man..its working

ramrongala — Thu, 24 Nov 2016 10:03:19 GMT

Thanks...its working