# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
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
Valued Contributor II

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

my QVW

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?

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

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

Valued Contributor II

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

Hi Arul

Thank you very much.

Paul

Honored Contributor III

Welcome