topic Return string from field if value meets expectation in QlikView

Return string from field if value meets expectation

renjithpl — Thu, 18 Nov 2010 13:39:40 GMT

Hi All,

I have a table like below:

i want to bring the string into a text box, with below condition.

=If(Rating >3, Category)

My output should be. Pencil

This is just a small table, but i have more than 50 Categories.

Please help me. THanks in advance

Ranjit

Anonymous — Fri, 19 Nov 2010 15:01:33 GMT

You shuld use an aggregation function...

try something like that: concat(DISTINCT If(Rating >3, Category))

regards

Matteo

Fri, 19 Nov 2010 15:50:24 GMT

Hi!!!

Here, your possible output values count are 0,1 or >1.

and text box can only hold one value. so you have to make your ouput as one value by using concat function.

use below function:

=concat(If(Rating >3, Category),';')

Regards,

Dixit Patel

renjithpl — Sat, 20 Nov 2010 05:40:59 GMT

It worked cool, thanks a lot dude..