topic Re: help in set expression in QlikView

help in set expression

Wed, 18 Jan 2012 13:27:26 GMT

Dear All,

Good Evening, as I have a expression = Count({<WEEK={'$(=max(WEEK))'}>} NBofINVOICE), its upto last year it was worked fine.

But now I have a issue and its showing wrong data, I think its not taking the latest year.

Please help me.

Regards

Joe

help in set expression

lironbaram — Wed, 18 Jan 2012 13:47:55 GMT

try something like

Count({<WEEK={'$(=max({<YEAR=max(YEAR)>}WEEK))'}>} NBofINVOICE),

help in set expression

Wed, 18 Jan 2012 13:54:31 GMT

Dear All,

I am not clear about the previous question, Using a text box object I am trying to dispay the Last WEEK NBofINVOICE, so I tried like this = Count({<WEEK={'$(=max(WEEK))'}>} NBofINVOICE),

Now I have a problem in displaying the last week value, I tried to add the

= Count({<YEAR={'$(=max(WEEK))'}>} NBofINVOICE), but its not helpful.

can you please help me...

Regards

Joe

YEAR	WEEK	NBofINVOICE
2011	49	5
2011	50	11
2011	51	10
2011	52	17
2011	53	8
2012	1	11
2012	2	7
2012	3	10

Re: help in set expression

SunilChauhan — Wed, 18 Jan 2012 14:11:33 GMT

try this

Count({<WEEK={$(=max(WEEK))}>} NBofINVOICE)

this also work

Count({<WEEK={$(=max({<YEAR=max(YEAR)>}WEEK))}>} NBofINVOICE)

hope this helps

Re: help in set expression

Wed, 18 Jan 2012 14:31:46 GMT

Hello Sunil,

Thanks for your reply, I tried but still its not comming. its taking only the 53rd WEEK.

My requirement is it should take the value of 2012 2nd WEEK value.

Regards

Joe

Re: help in set expression

lironbaram — Wed, 18 Jan 2012 14:50:35 GMT

this should work

=sum({<WEEK={"$(=max({<YEAR={"$(=max(YEAR))"}>}WEEK))"}>}NBofINVOICE)

attach is also an example

Re: help in set expression

Wed, 18 Jan 2012 16:06:44 GMT

Dear Liron,

Thanks a lot, excellent.....

I will try this and update you tomorrow.

Regards

Joe