Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
alberto_pozzi
New Contributor II

chart problem

hi

this is my problem:

i have a chart and i have to represent a value that is not in the cloud. it is external.

i find a solution using an expression and the " if " , but i would like to use a set analysis if it is possibile.

someone can help me?

i attach an example, my solution , very simple. i have the element year2 that is external and i use as dimension.

Regards.

1 Solution

Accepted Solutions
vgutkovsky
Honored Contributor II

chart problem

Alberto,

Actually, your IF is not working properly either. Here is the correct information:

year2 sum(price)
127
2005127
2006127
2007127
2008127
2009127
2010127


The set analysis expression would be: sum({<year2=P(year)>}price) which does produce the correct results (a flat line over 2 of the years).

Cheers,

1 Reply
vgutkovsky
Honored Contributor II

chart problem

Alberto,

Actually, your IF is not working properly either. Here is the correct information:

year2 sum(price)
127
2005127
2006127
2007127
2008127
2009127
2010127


The set analysis expression would be: sum({<year2=P(year)>}price) which does produce the correct results (a flat line over 2 of the years).

Cheers,