topic Re: help for set analysis in QlikView

help for set analysis

saumyashah90 — Fri, 04 Oct 2013 06:21:23 GMT

i have var1,var2,field1.

i have condition if (var1>var2 and var1>'123' and var1<'456',concat(field1))

i kept it in set analysis in this way

concat(if({< var1>var2, var1>{'123'}, var1<{'456'} >} field1)

it is showing error for 1st curly bracket.

sujeetsingh — Fri, 04 Oct 2013 06:32:52 GMT

See this may help you

saumyashah90 — Fri, 04 Oct 2013 06:35:40 GMT

I am good with two and conditions, only problem is with three or more and conditions

Fri, 04 Oct 2013 07:33:53 GMT

Hi,

i would rather write sth like

concat( {set} if (var1 > var 2, field))

where set = {< var1={">123 < 456"} >}

In fact, I do not know if you may write the "var1 > var2" inside the set because there is already a limitation on var1.

Fabrice

jagan — Fri, 04 Oct 2013 08:08:48 GMT

Hi Saumya,

Try this

if (var1>var2 and var1>123 and var1<456,concat(field1))

Remove single quotes and check.

Regards,

Jagan.

saumyashah90 — Fri, 04 Oct 2013 08:48:08 GMT

Set thing is not working

saumyashah90 — Fri, 04 Oct 2013 08:48:26 GMT

nope not working

Fri, 04 Oct 2013 09:59:45 GMT

Hi,

Try this...

if(var1>var2,if(var1>'123',if(var1<'456',concat(field1))))

Regards,

Anju

jagan — Fri, 04 Oct 2013 16:42:56 GMT

Hi Saumya,

Can you attach some sample data so that it would be easier to solve.

Regards,

Jagan.