topic Re: logic help! in QlikView

logic help!

abhaysingh — Wed, 18 Nov 2015 07:39:13 GMT

hi All,

I have one filed checkLogic which contain values let say A,,b,c,d,e,f

and two measure

Measure1= count({<Flag={'1'}>}Id/count(Total{<Flag={'0','1'}>}Id

Measure2=count({<Flag={'0'}>}Id/count(Total{<Flag={'0','1'}>}Id

these are representing in BAR Chart, so with dimension value A there are two bar chart, and so on

i want to change the color of bar with expression, Measure1 shud be green and measure 2 shud be red.

i know this is very basic, but not happening at my end..

kindly suggest

tamilarasu — Wed, 18 Nov 2015 07:48:07 GMT

Hi Abhay,

Right click on the chart and go to chart properties. There select colors tab and change the first two colors in the data appearance group.

Wed, 18 Nov 2015 07:53:59 GMT

try this

abhaysingh — Wed, 18 Nov 2015 07:57:16 GMT

sorry, i forget to mention i m trying this in Qliksense, so i have only option to achieve by Expression..

Wed, 18 Nov 2015 08:00:22 GMT

sorry abhay i have no idea in qliksense

abhaysingh — Wed, 18 Nov 2015 08:01:53 GMT

but their must be a way can be achieved by calculative expression right.. which we can do both in qlikview and qliksense