topic Re: Help needed in expression in QlikView

Help needed in expression

Sat, 04 Aug 2012 14:24:32 GMT

Dear,

Community.

I need a help in set analysis expression.

Kindly find the scenario in the attachment.

Thanks,

Mukram.

Mon, 06 Aug 2012 07:17:35 GMT

Dear Community.

Please somebody help me in the above scenario.

Thanks,

Mukram

sivarajs — Mon, 06 Aug 2012 12:40:32 GMT

The item code that you mentioned has both hanginperiod 0 and 24

so whenever you calculating it will reflects to your count

Mon, 06 Aug 2012 13:37:35 GMT

Dear

Sivaraj.

In example file i have only two items but in real time scenario i have thousands of items which meats that criteria.

so i can't filter all those records by using NOT WildMatch.

Thanks,

Mukram.

sivarajs — Tue, 07 Aug 2012 04:03:16 GMT

I just filtered but you need to look into hanginperiod of your itemcode

Because it has both 0 and 24 and confirm that you need 0 or 24

Item code	Hanginperiod
CC017325567NL	0
CC017325567NL	24

Item code

Hanginperiod

CC017325567NL