topic Text color in chart in QlikView

Text color in chart

Anonymous — Fri, 17 Jan 2014 21:49:24 GMT

Hi guys,

I have 2 the same charts. First chart - I combined 1 dimension; second -without combined.

I want to show different text color for my first chart.

The problem-when I combined my dimension (from 3 tags to 2 tags), stop working text color expression for combined tags.

Do you know how to resolve this issue?

Please see my attached file.

Thanks,

iktrayanov — Fri, 17 Jan 2014 22:29:03 GMT

Is that what you need?

Anonymous — Mon, 20 Jan 2014 16:54:50 GMT

No, I want to compare First time visitors with first -time visitors.

Something wrong with aggregation function

Please see attached file.

iktrayanov — Mon, 20 Jan 2014 18:12:42 GMT

You have problem with the above() function it returns null in some cases.

Anonymous — Tue, 21 Jan 2014 16:45:15 GMT

I don't understand why it works in Pivot table.

I just replace before to above.

Anonymous — Tue, 21 Jan 2014 16:47:28 GMT

I think it can understand my dimension

=If([qID_9705_Visit Frequency]='First time','First-Time Visitors',If([qID_9705_Visit Frequency]='2 to 5 times',

'Repeat Visitors',If([qID_9705_Visit Frequency]='6 times or more','Repeat Visitors',[qID_9705_Visit Frequency])))

in the chart

iktrayanov — Tue, 21 Jan 2014 17:03:22 GMT

I would try to create the calculated dimension in the load script. Because the bottom chart seems to work with normal dimension.

Regards,

Ivan

Anonymous — Tue, 21 Jan 2014 17:04:56 GMT

I did it.

it works. when I created the same condition in load script.