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

With out select SOURCE = WAGO & iTDS , how to make it display WAGO & iTDS line ?

Hi All

I using button to select only 4 company :-

COMPETITOR

(WAGO|iTDS)

May I know how to insert the above filter expression into below SET expression :-

sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}distinct REVENUE_C)/1000000

so that i can use this chart in QS.

Paul

1 Solution

Accepted Solutions
sunny_talwar

Try this:

sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000

View solution in original post

4 Replies
paulyeo11
Master
Master
Author

My QV Dcc

sunny_talwar

Try this:

sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000

paulyeo11
Master
Master
Author

Hi Sunny

thank you very much it work fine,.

PAul

sunny_talwar

Awesome