Qlik Sense - Conditional Hide / Show Measures in Pivot Table

[eng19872]

Hi,

Sample file is attached, please have a look into and suggest me the solution.

if(Sum(total <Dim1> {$<[Field 1]={1}>} [xxx]) < 0, 1, 0))

I am using pivot table and I would like to Hide / Show the measure when the total value is in Negative. There are two dimensions in the Pivot Table.

When I am writing given above expression in Qlik Sense > Measures >  "Show column if" then it is not working and row is not hiding.

How to fix it?

[eng19872]

Qlik Gurus, your help required.

[johngouws]

I have not tried this, but the only way I think you can achieve this is to make the 2 dimensions also 'calculated dimension' like it is called in QlikView. Basically you say "if(<your expression> > 0, <Dimension>). 

Other than that I don't think it will work. 

Have you tried not using a pivot table? 

[eng19872]

The expression is not working for hide / show for conditional hide show however, it works fine when I am writing in expression section.

[miskinmaz]

Please share the sample data.

[eng19872]

Hi,

Please check attached file as shared with main thread. File name is "PositiveNegativeApp.qvf".

[eng19872]

Hi Miskinmaz,

Any solution?

[miskinmaz]

with respect to which dimension the hide show should work? Name or product

Just to make the req clear from below screen shot please let me know which column you want to hide:

[eng19872]

Hi Miskinmaz,

I need a flag when I select then there must be only Negative Values on the basis of row total.

Means, when I select flag NA - A should be appear because it's total is in Negative and when I deselect then all the values visible.

[eng19872]

Hi Miskinmaz and Qlik Experts,

Can you share me the solution?