Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
eng19872
Creator
Creator

Qlik Sense - Conditional Hide / Show Measures in Pivot Table

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?

15 Replies
eng19872
Creator
Creator
Author

Qlik Gurus, your help required.

johngouws
Partner - Specialist
Partner - Specialist

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
Creator
Creator
Author

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

Please share the sample data.

eng19872
Creator
Creator
Author

Hi,

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

miskinmaz
Creator III
Creator III

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:

 

comm.JPG

eng19872
Creator
Creator
Author

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
Creator
Creator
Author

Hi Miskinmaz and Qlik Experts,

Can you share me the solution?