topic How to make SOURCE={'TDSS'} Dynamic ? in QlikView

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

paulyeo11 — Tue, 26 Jul 2016 11:44:38 GMT

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

paulyeo11 — Tue, 26 Jul 2016 11:45:37 GMT

my QVW

arulsettu — Tue, 26 Jul 2016 11:56:11 GMT

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

paulyeo11 — Tue, 26 Jul 2016 12:09:44 GMT

Hi Arul

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

Paul

arulsettu — Tue, 26 Jul 2016 12:12:54 GMT

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 — Tue, 26 Jul 2016 12:21:39 GMT

Hi Arul

Thank you very much.

Paul

arulsettu — Tue, 26 Jul 2016 12:22:12 GMT

Welcome