Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to make SOURCE={'TDSS'} Dynamic ?

Hi All


Now i need 3 Table , my goal is make it only 1 table .

Expression for TDSS :-

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"},SOURCE={'TDSS'}>}BK_TAR)

Expression for TDST

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"},SOURCE={'TDST'}>}BK_TAR)

Expression for TDSID :-

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"},SOURCE={'TDSID'}>}BK_TAR)

May i know how to make it dynamic :-

when i select SOURCE = TDSS , Table 1 will display Monthly target = 76,389.00

when i select SOURCE = TDST , Table 1 will display Monthly target = 34,722.00

when i select SOURCE = TDSID , Table 1 will display Monthly target = 27,777.78

Paul

1 Solution

Accepted Solutions
arulsettu
Honored Contributor III

Re: How to make SOURCE={'TDSS'} Dynamic ?

in single chart use this expression

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"},SOURCE-={'ADL','TDSKL','TDSPG',''}>}BK_TAR)


other than this values from list box if u select the chart will change

6 Replies
paulyeo11
Valued Contributor II

Re: How to make SOURCE={'TDSS'} Dynamic ?

my QVW

arulsettu
Honored Contributor III

Re: How to make SOURCE={'TDSS'} Dynamic ?

you want to combine three charts into one? and other than the three SOURCE chart should not show the value?

paulyeo11
Valued Contributor II

Re: How to make SOURCE={'TDSS'} Dynamic ?

Hi Arul

Yes you are right. only 3 out of 5 value label have value.

Paul

arulsettu
Honored Contributor III

Re: How to make SOURCE={'TDSS'} Dynamic ?

in single chart use this expression

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"},SOURCE-={'ADL','TDSKL','TDSPG',''}>}BK_TAR)


other than this values from list box if u select the chart will change

paulyeo11
Valued Contributor II

Re: How to make SOURCE={'TDSS'} Dynamic ?

Hi Arul

Thank you very much.

Paul

arulsettu
Honored Contributor III

Re: How to make SOURCE={'TDSS'} Dynamic ?

Welcome

Community Browser