Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
n1ef5ng1
Creator
Creator

if statement on Dimension

Hi, I am working on pivot table, on the dimension tab.

Example, my variable in the field consist of A,B,C,D

Therefore, if(myfield = 'A','A','others')

others will tabulate B,C,D for me

However,i would want my 'others' to consist of everything in that variable, say A,B,C,D.

any help is appreciated, thanks

0 Replies