# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Valued Contributor II

## How to make my target chart ok when not select current month and yr ?

Hi All

chart 1 expression work fine when select current month and year :-

sum({\$<year = {\$(=max(year)-0)}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>}sales_target/\$(Columndim89)/1000)

, \$(vMoneyFormatK))

Table 1 expression work fine when not select month and year :-

Sum({\$<year = {\$(=Max(year)-0)}, month = {"<=\$(=Max({<year={\$(=Max(year))}, sales = {'*'}>} month))"}>}sales_target/\$(Columndim89)/1000)

, \$(vMoneyFormatK))

In order to make chart 2 don't need to select current month and year , i use Table 1 expression for chart 2 expression :-

Sum({\$<year = {\$(=Max(year)-0)}, month = {"<=\$(=Max({<year={\$(=Max(year))}, sales = {'*'}>} month))"}>}sales_target/\$(Columndim89)/1000)

, \$(vMoneyFormatK))

I expect Chart 2 to display the bar value same as Table 1. But it does not work. Hope some one can help me.

Paul

1 Solution

Accepted Solutions
New Contributor III

## Re: How to make my target chart ok when not select current month and yr ?

I tested your Set Analysis Expressions and by adding them to a new Straight Table without any Labels I can see what the values of the variables within an expression and Set  Analysis are. So then I discoverd that the Set Analysis within your table constantly showing the current month disregarding the selection, and the graph was changing the value of Month from the current Month (with selection) to Month 12 (without Selection).

Both expressions have a different Set Analysis, so if you make the expression of the graph equal to the expression of the table, it will show the correct amount (115K), wether you have a selection or not.

I the attachment you'll find your edited QVW. You'll also find the straight tables with no lables, so you can investigate the values of the variables in the popup of the column headers.

3 Replies
New Contributor III

## Re: How to make my target chart ok when not select current month and yr ?

I tested your Set Analysis Expressions and by adding them to a new Straight Table without any Labels I can see what the values of the variables within an expression and Set  Analysis are. So then I discoverd that the Set Analysis within your table constantly showing the current month disregarding the selection, and the graph was changing the value of Month from the current Month (with selection) to Month 12 (without Selection).

Both expressions have a different Set Analysis, so if you make the expression of the graph equal to the expression of the table, it will show the correct amount (115K), wether you have a selection or not.

I the attachment you'll find your edited QVW. You'll also find the straight tables with no lables, so you can investigate the values of the variables in the popup of the column headers.

MVP

## Re: How to make my target chart ok when not select current month and yr ?

to replicate table1 expression:

=

money(

Sum({\$<year = {\$(=Max(year)-0)}, month = {"<=\$(=Max({<year={\$(=Max(year))}, sales = {'*'}>} month))"}>}sales_target/\$(Columndim89)/1000)

, \$(vMoneyFormatK))

Valued Contributor II

## Re: How to make my target chart ok when not select current month and yr ?

Hi Stefan

Yes you are right , i just discover when i download the file attach from Jorgen. Many thank for high lighted to me. sorry i am too careless.

Paul