topic Need Help!!! in QlikView

Need Help!!!

Tue, 22 Jul 2014 06:09:30 GMT

Hi All

can any one suggest an optimised formula to get the

count of items those order is one for select month and its previous month. for that it has to check select month order weather it is one or not if so it has to chek previous month order if its order is also one then it has to give the count of items.

i have 10+ lac records to apply on it suggest me an expression. see the below exmple data.

Ex data:

item	order	month	prevmonth
Cdas	4	jun	may
cfds	2	july	jun
clds	1	feb	jan
gdms	1	mar	feb
bdms	1	Apr	mar
lfgd	4	Aug	jul
dqrs	1	feb	jan

Re: Need Help!!!

jagan — Tue, 22 Jul 2014 06:26:20 GMT

Hi John,

What is your expected output, can you explain it with an example?

Regards,

Jagan.

Re: Need Help!!!

Tue, 22 Jul 2014 06:44:24 GMT

Hi Jagan Mohan

The Senario is : i have month and previous month values if i select any month in any year it has to check in that moth order is zero or not if it is yes it has to check previous month order if it so then it should return the count of item if not it shouldn't return anything.

in the above example i am expecting : if i select mar my out put is 1