topic True and false case in QlikView

True and false case

Thu, 30 Jun 2011 08:43:18 GMT

Dear Friends,

i have one column named ITEM having values 10,20,30,..
Help me to write expression in chart which will tell me
true if 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..

True and false case

kaushiknsolanki — Thu, 30 Jun 2011 09:23:18 GMT

Hi,

Try this in TextBox.

if(count (distinct ITEM ) < count(ITEM),'False','True')

Regards,

Kaushik Solanki

True and false case

Thu, 30 Jun 2011 11:51:03 GMT

Hi,

you can also do the same

if(count (distinct ITEM ) < count(ITEM),'False','True') as Status,

while you are pulling the data ......