topic Re: Selecting on string variable in QlikView

Selecting on string variable

Thu, 25 Apr 2013 13:00:51 GMT

Basically, I want a chart to be displayed for just one value in a string variable i.e. if SESYEAR='2009'.

Also, where is such a selection (condition) placed ? The General tab?

Any help,

Gratefully received

Racine62

swuehl — Thu, 25 Apr 2013 13:05:13 GMT

Go to Layout tab in chart properties and enter as 'Show' conditional expression in the appropriate field:

SESYEAR='2009'

Thu, 25 Apr 2013 13:54:24 GMT

Thanks for responding. I've not explained myself very well.

Basically, I want a separate chart for each year (2009 to 2013) and for them to on display all the time, not just when they are selected.

Regards,

Racine62

swuehl — Thu, 25 Apr 2013 16:50:35 GMT

Ok, let's assume you create a chart with dimension Customer and you want to show Sales for the different year.

Create 4 charts each with dimension Customer and then using 1 expression for the first

=sum({<SESYEAR = {'2009'} >} Sales)

resp.

=sum({<SESYEAR = {'2010'} >} Sales)

=sum({<SESYEAR = {'2011'} >} Sales)

=sum({<SESYEAR = {'2012'} >} Sales)

=sum({<SESYEAR = {'2013'} >} Sales)

for the other ones (where SESYEAR is your sales year field).

Hope this helps,

Stefan