3 Replies Latest reply: Aug 27, 2012 4:13 PM by Rebecca Molstad RSS

    Visual Cue Expression not working?

    Bryan Herold

      Hello All -

       

      I am attempting to use the following expression for highlighting data in my straight table:

       

      =date(monthend(USInventory_promise_date)-6)

       

       

      The column that this is being applied to is a date column (Prom Date).

      I am not getting the data highlighted as I would have expected. 

      Ultimately what this should do is highlight anything that has a Prom Date in the last 7 days of the month.

       

      To test my expression, I added a calculated dimension to my chart, which shows that the expression is calculating the desired date (screen shot below - right column - Expression Date Test).

       

      I would have expected the highlighted items in my screen shot below to have been picked up by that expression(above) in the visual Cues "Upper".

       

      Screen-QlikviewVisCue.png

      Interpreting the first row of data;

       

      The way I am reading it would be If the Promise Date is >= 6/24/12 then highlight.

       

      If I hard code the date in the expression (simply put =date('6/24/12') the highlighting works as expected.

       

      Is there some fine point I am missing with date compares in expressions used for visual cues?