Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Micki
Creator
Creator

Myltiply by to two only total in straight table

Hi folks, 

Does it possible to multiply by 2 only total in straight table 

can I apply condition if where total ?

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes. You can test the Dimensionality(). It is "0" for the Total row.  So make your measure like:

Sum(x) * If(Dimensionality() = 0, 2, 1)

-Rob

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes. You can test the Dimensionality(). It is "0" for the Total row.  So make your measure like:

Sum(x) * If(Dimensionality() = 0, 2, 1)

-Rob

Micki
Creator
Creator
Author

@rwunderlich , Thank you so much!!!!!!!!!!