Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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

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

Try this:

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

4 Replies
paulyeo11
Valued Contributor II

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

My QV Dcc

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

Try this:

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

paulyeo11
Valued Contributor II

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

Hi Sunny

thank you very much it work fine,.

PAul

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

Awesome

Community Browser