Update result for selected Date

Sat, 07 Feb 2015 22:29:59 GMT

Hello Everyone,

I am hoping that someone can help with my question here. Basically I have a test that calculates employees that have >20% cash to expense ratio from an employee table. THis table also has a date. Loading all the data works fine for the test but when selecting a specific date ( for example, Aug 2013) it does not update. It still is in reference to the entire data population. How do I make sure that the result updates for only the specified date selected?

Test:

MAPPING LOAD
Concur_Emp_ID
,IF(Sum_Cash_Emp/Sum_All_Emp >= .2 ,'Yes','No')
RESIDENT TE_Date;

Thank You!

Re: Update result for selected Date

Gysbert_Wassenaar — Mon, 09 Feb 2015 09:44:24 GMT

I'm not sure I understand your question. Are you perhaps looking for a where clause?

MAPPING LOAD
Concur_Emp_ID
,IF(Sum_Cash_Emp/Sum_All_Emp >= .2 ,'Yes','No')
RESIDENT TE_Date

WHERE MyDate = ..... ;

topic Update result for selected Date in QlikView

Update result for selected Date

Re: Update result for selected Date