topic Need help urgently, please in QlikView

Need help urgently, please

tracycrown — Sun, 04 Apr 2010 10:51:48 GMT

Dear QV Experts

Can you help me urgently to create 3 columns next to Plan in the report :

Column 1 : Actual minus Plan ;

Column 2 : Actual minus Outlook &

Column 3 : Plan minus Outlook

Thank you very much, Tracy [:(]

Need help urgently, please

deepakk — Sun, 04 Apr 2010 10:59:25 GMT

If you can provide the excel sheets then I can give it a try..........

Need help urgently, please

tracycrown — Sun, 04 Apr 2010 12:42:50 GMT

Dear Deepak

Attach excel worksheets per your request, please help me urgently.

Thank you very much, Tracy

Need help urgently, please

deepakk — Sun, 04 Apr 2010 14:31:15 GMT

HI I have done it for Student , You can try it out for the rest.

Need help urgently, please

tracycrown — Sun, 04 Apr 2010 17:03:55 GMT

Dear Mr Deepak

Well done, you have done a good job, I really appreciate your kind effort and quick response.

Please advise how to modify the script so that it shows only 1 column (Actual minus Plan) instead 3 when users select say Actual & Plan in F2. ie. Auto hide (Actual minus Outlook) and (Plan minus Outlook). I wonder can that be done ?.

Thank you very much, Tracy

Need help urgently, please

deepakk — Mon, 05 Apr 2010 06:37:17 GMT

Just click on the Actual minus PLan others will not be shown..!!

Need help urgently, please

tracycrown — Mon, 05 Apr 2010 09:10:11 GMT

Dear Mr Deepak

Maybe I did not explain clearly what I really need.

Assuming that we allow users to select either Actual, Plan or Outlook in F2 (ie. excluding Actual-Plan, Actual-Outlook & Plan-Outlook). When users select Actual & Plan, the report will show Atual, Plan and Actual-Plan etc.

Thank you so much, Tracy

Need help urgently, please

tracycrown — Thu, 15 Apr 2010 15:52:55 GMT

Dear Mr. Deepak

I have not heard from you since Apr 5, 2010, kindly advise what is the outcome now base on following conditions :

I would like F2 to show only Actual, Plan, Outlook and Variance (computed below)

If F2 = 'Actual' and F2 = 'Plan' then Variance = Actual - Plan

if F2 = 'Actual' and F2 = 'Outlook' then Variance = Actual - Outlook

if F2 = 'Plan' and F2 = 'Outlook' then Variance = Plan - Outlook

Thank you so much, Tracy