Choosing dimension values inside set analysis

Thu, 18 Apr 2013 13:19:04 GMT

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.

Re: Choosing dimension values inside set analysis

Thu, 18 Apr 2013 14:14:15 GMT

Hello Bill,

Thanks a lot for your email, but I dont see any reply message or answer in the discussion thread. Do you have a solution to my question. If so please feel free to share. Thanks in advance!

Best Regards,

M.Aushik

topic Re: Choosing dimension values inside set analysis in QlikView

Choosing dimension values inside set analysis

Re: Choosing dimension values inside set analysis