topic condition expression in QlikView

condition expression

Anonymous — Fri, 22 Mar 2013 20:37:28 GMT

Hi,

Could you help me to create condition for calculation?

Question1	Question2
a	Female
b
c
d
e
a	Male
b
c
d
e
a	Male
b
c
d
e
a	Female
b
c
d
e
a
b
c
d
e

Count the number of values for column B (Question2) if the number of corresponding distinct values for column A (Question1) equals or more than 2.

Thanks and I hope you understand what I want,

Re: condition expression

sushil353 — Sat, 23 Mar 2013 15:19:51 GMT

Sorry, Your requirement is not clear.

What should be the final result of above table?

so that we can understand your requirement.

HTH

Sushil

Re: condition expression

Anonymous — Mon, 25 Mar 2013 14:34:31 GMT

I need to create condition. It should work, when in Question1 has answers in Question2 more than for 1.

If you see in my table. Question2 has answers only for a in Questions1.

Condition should work, when Qustion2 has answers more than for 1 any tag(a and b, or b and c ...)

Thanks,