Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
razvan_brais
Creator III
Creator III

Nested IF makes proccessing havier for a straight table

Hy there , I have a Straight table with 4 dimensions . For each dimension I have calculated what to show using nested if statement.

The statement looks something like this :

if(Match(ID,GetFieldSelections(ID)),ID,if(Match(NO,GetFieldSelections(NO)),ID,if(Match(DATE,GetFieldSelections(DATE)),ID)))

But this nested IF`s makes the proccessing real heavy . Is there any other way to acomplish the same behavior without using this calculated dimmension?

Thank you.

0 Replies