Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.


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

Community Browser