topic Re: Visual Cues not working as expected in QlikView

Visual Cues not working as expected

ivandrago — Tue, 03 Sep 2013 22:37:43 GMT

Hi,

On the attached Document I only want the Vendor Price to turn Green if it is cheaper than the Order Price, it is currently doing this but I only want the one to turn green if its the cheaper out of the other vendors.

So for orderId = 1, all the VendorCodes have a cheaper price than the Actual OrderPrice, but the cheapest one is the VendorCode "HEW001" which I only want this to show as Green.

Thanks

Re: Visual Cues not working as expected

Anonymous — Tue, 03 Sep 2013 23:48:49 GMT

Ivan,

Unfortunately Visual Cues don't work with expressions, we can use only numbers. Try, for example 13 and see that it works.

For colors depending on expressions, use attribute expression for background color.

Regards,

Michael

Re: Visual Cues not working as expected

amars — Wed, 04 Sep 2013 02:16:10 GMT

Hi Evan,

Rather than Visual Cues, you can use Expression's Background Color and Text Color.

Please find you example attached here.

Thanks

Re: Visual Cues not working as expected

ivandrago — Wed, 04 Sep 2013 08:11:46 GMT

Hi Michael,

It still is highlighting all of the prices, I only want it to hightlight the cheapeat one for each orderid?

So for example orderId 2, I only want the Price for the VendorCode "HEW001" to be highlighted as that is the cheapest one out of the 3 thanks.

Thanks

Re: Re: Visual Cues not working as expected

swuehl — Wed, 04 Sep 2013 08:27:49 GMT

I assume you want the cheapest price per productID, not per orderID, which is smaller than orderPrice.

Maybe like attached (or similar, when you need to apply other conditions). Look into the background color attribute expression.

Re: Visual Cues not working as expected

christophebrault — Wed, 04 Sep 2013 08:29:01 GMT

Hi,

Please try this expression as background colour of your expression :

if(sum(Price)<sum(OrderPrice)

and aggr(rank(-sum(Price))=1,productId,VendorCode)

,LightGreen())

Replace productId with orderid if you only want this for order and not product

Re: Visual Cues not working as expected

neetu_singh — Wed, 04 Sep 2013 10:14:16 GMT

Hi,

Please find attached qvw, it will help you out. Have exactly done as per your requirement.

Regards

Neetu Singh