topic Dynamic Visual Cues in QlikView

Dynamic Visual Cues

AbhijitBansode — Thu, 28 Nov 2013 08:08:47 GMT

Hi,

I am displaying Count of orders, Category wise in pivot table.

There are two levels in each order, For each level, the threshold count of order is different.

I have these threshlod limits in the excel table and I can link that with the Category field.

Please refer attached sptreadsheet for the details on the requirement.

What expressions do I need to write to assign dynamic colors to the values in pivot table.

Thanks,

Abhijit

Re: Dynamic Visual Cues

hic — Thu, 28 Nov 2013 10:20:37 GMT

Visual cues is an old way to put color on the data points. We recommend that you don't use them. Instead, you should use the Background Color that you can find under Expressions. These can be made to be dynamic.

HIC

Re: Dynamic Visual Cues

AbhijitBansode — Thu, 28 Nov 2013 10:50:51 GMT

Thank you HIC for the concern.

I am trying using Backgroung color only, just named at as Visual cues.

but I'm not able to create proper link with Threshold table.

the value I want to check against expression need to come form this table.

Can you please provide me any idea of how to do it so that I don't need to hardcode any value to check against expression.

Please refer attached spreadsheet and let me know if more details are required on the query.

Thanks,

Abhijit

Re: Dynamic Visual Cues

sundarakumar — Thu, 28 Nov 2013 11:59:28 GMT

HI Abhijit,

It cannot be achived in Visual cues.

Instead it can be done using text colour option in expression...

Please find the attachment....

Hope this helps...

-Sundar

Re: Dynamic Visual Cues

hic — Thu, 28 Nov 2013 18:58:44 GMT

You need to first reshape your color/condition table to something like this:

In other words - each color has a numeric interval. Then you need to load this into your data model using intervalmatch. See http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch.

Finally, you need to assign colors to the text as I have indicated above. See also http://community.qlik.com/blogs/qlikviewdesignblog/2012/12/04/colors-in-charts

HIC

Re: Dynamic Visual Cues

AbhijitBansode — Mon, 02 Dec 2013 09:47:27 GMT

Thank you HIC, for the help.

In my case Events table is not static, as Events are calculated on the fly.

OrderId is the column present in fact table.

So, my Interval match syntax become:

intervalmatch(Count(OrderId)) -- which is wrong.

Also, I can not precalculate count(OrderId) at script level because I want to view this count with respect to different dimension present in the data model and it would be impractical to do this.

I am not sure how I can utilize IntervalMatch functionality in such case.

Though I've achieved the required output ay UI level by directly hardcoding the threshold limits in the if expressions, but it would be much more aprreaciable if it can be achieved at script level as it will minimize future modification time in case if there is any change/new addition in threshold limits.

Thanks,

Abhijit Bansode