topic Re: Calculation !!!!! in QlikView

Calculation !!!!!

Thu, 15 May 2014 11:23:16 GMT

Guys

Please Can u give approaches for this Calculation

Here i want to cal calculate SLAVE For Each respond Id By Using 101,102,103,104,105

please find my attachment

Re: Calculation !!!!!

Thu, 15 May 2014 11:28:07 GMT

Why not to croos your 101,102,103.... columns into rows?

You will be able to use it as a dimension and then your calculations should be easier.

regards

Darek

Re: Calculation !!!!!

tresB — Thu, 15 May 2014 11:29:35 GMT

Like attached qvw?

Re: Calculation !!!!!

Thu, 15 May 2014 11:31:50 GMT

Actually i done generic load by using for statements and left join

For calculate SLAVE Column again cross table means it will comes original status

Re: Calculation !!!!!

Thu, 15 May 2014 12:44:38 GMT

Sunnel,

your data model have to correspond your calculation needs.

I donk exactly know what is you 101, 102 .... fields business role, but for first sight it looks like dimension, especially if in the future you expect more of them.

In fact i don't know what problem do you have with calculation you need

regards

Darek