Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
user467341
Creator II
Creator II

Set analysis count IF in pivot table

I have a pivot table with n rows and 3 measures.

Measure1        Measure2          Measure3

2                            0                             $0

1                            1                             $13

31                        42                           $433

3                           0                             $0

How can I use set analysis (or IF) to do this logic

If measure2 is 0, then measure1 will be 0 else if measure2 is > 0, then measure1 is the same.

Labels (1)
1 Reply
Vegar
MVP
MVP

Try this

=if(measure2=0,0,measure1)

In your case (as I understand it)"even this should work.

=Sign(measure2) * measure1