Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to implement trieif in this case

Dear Friends,

i have one column named ITEM having values 10,20,30,..
Help me to write expression in chart which will tell me
trieif values are not repeated and false if values are repeated..example..
If ITEM contains 10,20,20,30 on selection....so inthis case it would be false as 20 is repeating..

Thanks in advance friends

1 Reply
MVP
MVP

How to implement trieif in this case

Hi Kamalnaithani,

you could compare count (ITEM) with count(distinct ITEM) to get what you want, I think.

if(count(ITEM) > count(distinct ITEM), 'false', 'true')

Regards,

Stefan