1 Reply Latest reply: Apr 18, 2013 10:14 AM by Aushik.Makdoom RSS

    Choosing dimension values inside set analysis

      I have single qlikview table where you have information about when a  Case\Workorder was created and when it was completed. It contains the WO Created Date and WO Completed date and the WO ID.


      Now on a particular day I wanted to see the number of WO created and number of WOs completed.


      To achieve this I created a Calender table that cointains the calender date and I use it as a data island (not linked to any QV table)- let us call it common date


      Then in a simple straight table I use the Common date as my dimension and I try to calculate the number of created cases on a date as below in set analysis.


      Dimension: Common  Date

      Completed Cases Expression:

      Sum({<[WO Completed Date]= {"=[WO Completed Date]= CommonDate"}>}WO).


      The above formula doesnot give me results. If I try to use a normal condition as below I get the results, but the performance is very bad.


      Sum(IF(CommonDate=[WO Completed Date],WO)).


      Can someone please help me to achieve the result with set analysis ?


      Please let me know if you need more details.