topic Re: If Condition in QlikView

If Condition

jyothish8807 — Wed, 28 Aug 2013 10:45:13 GMT

I have 3 columns.

name Subject Marks

aa xx 20

aa yy 45

bb ee 33

No i want the count of marks which are <20, between 20 and 50,>50 for each student.

Regards

narender123 — Wed, 28 Aug 2013 10:57:19 GMT

Hi,

try this.

=count({<marks={"<30"}>}name)

See the attach file.

Wed, 28 Aug 2013 10:58:24 GMT

Hi,

in 3 expression:

count({<Marks={"<20"}>}Name)

count({<Marks={">=20"}*Marks={"<=50"}>}Name)

count({<Marks={">50"}>}Name)

narender123 — Wed, 28 Aug 2013 11:07:46 GMT

you can show this in pivot table for better understand.

See the attachment.

Thanks.

Narender

CELAMBARASAN — Wed, 28 Aug 2013 11:15:55 GMT

Try with this

count({<Marks={"<20"}>} Name)

count({<Marks={">=20<=50"} Name)

count({<Marks={">50"}>} Name)