2 Replies Latest reply: Sep 20, 2010 3:29 AM by Matthew Green RSS

    How can an Expression cause a table not to display on the web

    Matthew Green

      I have a report that displays perfectly fine in the Developer. However when it is loaded via qlikview/qlikview certain tables appear blank.

      I have done some testing with tables appearing on the same sheet, and have found that it is the Expression that is causing the issue.

      The tables are essentially the same, just sorting the data is different.

      Here is an expression that works

       

      COUNT({$<TypeMap={'Urgent'},Region={'W'},PST_Transfer={'0'} ,~VEHLOC={'DEA'}>} CallSign)

      But this one doesn't

       

      COUNT({$<Region={'S'},PST_Transfer={'1'},~VEHLOC={'DEA'}>} CallSign)