Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

set expression can display YTD sales , but can allow me click on month = feb

Hi All

I have currenct yr set expression below :-

sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} REVENUE/1000)

This expression give me YTD sales for 2015 = 1592 is correct.

But when i click on Feb month , it display only feb sales = 526 , which is not what i want.

when i press on feb , i need it display sum of jan and feb revenue 2015 = 1592.

when i click on jan , i need it display sum of jan revenue 2015 = 1065.

Hope some one can herlp me.

Paul

1 Solution

Accepted Solutions
maxgro
MVP
MVP

you have to check your model: you have a date field in mixed format (number and string,some null too), two month field (Month and month) etc,..... and this isn't a good start to build the charts

if you use month (not Month) in listbox and year+month as dimension your expression semms to work

1.png

View solution in original post

4 Replies
paulyeo11
Master
Master
Author

Hi All

Enclosed my QV doc.

MK_QSL
MVP
MVP

sum({$<YearMonth=, year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} REVENUE/1000)

maxgro
MVP
MVP

you have to check your model: you have a date field in mixed format (number and string,some null too), two month field (Month and month) etc,..... and this isn't a good start to build the charts

if you use month (not Month) in listbox and year+month as dimension your expression semms to work

1.png

paulyeo11
Master
Master
Author

Hi Sir

Thank you very much . it work now.

Paul