topic Re: how to fixed color by data in QlikView

how to fixed color by data

Fri, 10 Aug 2012 12:06:00 GMT

Hi,

I'm doin this in the dimension.

if(aggr(days,sales) >1, '>1' ,
if(aggr(days,sales) >2, '>2'

) .. and many many more if() for other days buckets , also consist of negative days.

... basically, we will have the days bucket in the chart.

Then, in experession, i do a count(), so we will have the counting of how many sales for more than 1 day, 2 days...etc

and i stacked it. now, the problem is, how can i set a color for >1 to be always green?

i did this... some bucket works, and some doesnt... any helps please....

if(aggr(days,sales) >1, green(),
if(aggr(days,sales) >2, red()

)

Thansk.

Re: how to fixed color by data

Fri, 10 Aug 2012 12:19:35 GMT

Hi,

what is the kind of chart/table that are you working on?

In general, there is Background color property of dimension/expression, where color can be set.

regards

Re: how to fixed color by data

Fri, 10 Aug 2012 12:23:03 GMT

yup, i'm putting it directly in background color, but for some reason, certain level of if() wont display the color properly... and i don't know why .... maybe aggr() is not good ?