topic Re: using dimensionality og visual cues in QlikView

using dimensionality og visual cues

Tue, 02 Jul 2013 08:38:24 GMT

I got a pivot tabel showing amount of salesitems sold per month and year.

so it count items sold i january 2011 to be 31

items sold i january 2012 to be 31

and items sold in january 2013 to be 43

because items sold in 2013 is over the two others years I want the number or backgorund to be green.

If the number is equal it should be yellow or lower it should be red

How do I go about that???

Re: using dimensionality og visual cues

jonathandienst — Tue, 02 Jul 2013 10:02:36 GMT

Click the small + sign next to the expression for amount sold in the properties dialog for your table. Select Background Colour and add an expression to set the colour to green, like this

=If(<your expression goes here>, LightGreen())

Hope that helps

Jonathan

Re: using dimensionality og visual cues

Wed, 03 Jul 2013 05:39:23 GMT

Hi Jonathan

Yeah that is ok, but I got three dimension, see table

Ex. for 2013 in the total I want the background to be green except for april where the number is lower – it should be red?????

søren

Fra: Jonathan Dienst

Sendt: 2. juli 2013 12:03

Til: Schou, Hans Henrik Søren (SSC009)

Emne: - Re: using dimensionality og visual cues

QlikCommunity<http://community.qlik.com/index.jspa>

Re: using dimensionality og visual cues

created by Jonathan Dienst<http://community.qlik.com/people/jontydkpi> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/363063#363063>

Re: using dimensionality og visual cues

Wed, 03 Jul 2013 05:59:12 GMT

Hi again

As you can see I got it working somehow

But only on the total – I want it working on the months

I used this in the expression(text color)

=if(count(if(ANMAAR='2013',JOURNALNR)) >= count(if(ANMAAR='2012',JOURNALNR)), green(), red())

How do I get it to work on the months

søren

Fra: Jonathan Dienst

Sendt: 2. juli 2013 12:03

Til: Schou, Hans Henrik Søren (SSC009)

Emne: - Re: using dimensionality og visual cues

QlikCommunity<http://community.qlik.com/index.jspa>

Re: using dimensionality og visual cues

created by Jonathan Dienst<http://community.qlik.com/people/jontydkpi> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/363063#363063>