topic Calculation on dimension in QlikView

Calculation on dimension

Fri, 08 Jul 2011 02:38:31 GMT

Dear Experts,

Please check on the attached files and help us how to create the calculation for SALES vs FORCAST. We tried " =IF([TYPE]='SALES',SUM([S_LBS]),IF([TYPE]='FORECAST',SUM([F_LBS]),SUM([SF_LBS]+[S_LBS]))) " and it did not work.

Basically we need to know if sucha calculation is doable or not?

Thanks,

Nima

Calculation on dimension

kaushiknsolanki — Fri, 08 Jul 2011 07:04:22 GMT

Hi,

Can you please functionaly say what you are trying to do ..?

Regards,

Kaushik Solanki

Calculation on dimension

Fri, 08 Jul 2011 12:57:04 GMT

Hi ,

Thanks for replying.

Make it simple, let's say if we want to add SALES & FORCAST like (SALES+FORCAST) OR (SALES - FORCAST) or any other calculation between 2 dim.

Thanks,

Nima

Re: Calculation on dimension

nagaiank — Fri, 08 Jul 2011 13:18:32 GMT

Are you looking for a solution similar to what is in the attached qvw file?

Calculation on dimension

Fri, 08 Jul 2011 14:17:24 GMT

Thanks Krishnamoorty,

You save my life

Nima,