Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

help in set expression

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

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

ok

this should work

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

attach is also an example

View solution in original post

6 Replies
lironbaram
Partner - Master III
Partner - Master III

try something like

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

Not applicable
Author

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

YEARWEEKNBofINVOICE
2011495
20115011
20115110
20115217
2011538
2012111
201227
2012310
SunilChauhan
Champion II
Champion II

try this

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

or

this also work

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


hope this helps


Sunil Chauhan
Not applicable
Author

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

lironbaram
Partner - Master III
Partner - Master III

ok

this should work

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

attach is also an example

Not applicable
Author

Dear Liron,

Thanks a lot, excellent.....

I will try this and update you tomorrow.

Regards

Joe