topic Re: adding calculated values in dimension in QlikView

adding calculated values in dimension

sarfaraz_sheikh — Thu, 16 Apr 2015 11:24:11 GMT

Dear All ,

I am stuck in one problem ....Look at my table below ...I want to add one more value in Remarks which will show the percentage between two fields.There is requirement like this from user..

For Example: CExcellent is what Percentage of AFaboulous

I want the output like below snapshot ....Look at below snapshot conversion values has added there ..but my concern is i should get percetage there and calculation will be like this

57000 / 212000 * 100 = 27% ......27 % should show as Sum of salary of conversion value.

I tried with below code ..........but not getting as expected ...i think i am doing wrong somewhere ..kindly help

Re: adding calculated values in dimension

sarfaraz_sheikh — Thu, 16 Apr 2015 11:47:41 GMT

any help would be much appriciable ....Dear hic please suggest any way

sarfaraz

Re: adding calculated values in dimension

Thu, 16 Apr 2015 11:50:36 GMT

Hi,

what is the expression for that conversion?

Re: adding calculated values in dimension

sarfaraz_sheikh — Thu, 16 Apr 2015 11:58:47 GMT

Hi,

i am using below code to achive the same .....

Load

'Conversion' AS Remarks,

Lookup('SALARY','Remarks','CExcellent','Raw') / SALARY * 100 AS SALARY

resident Raw where Wildmatch(Remarks,'AFaboulous');

Sarfaraz

Re: adding calculated values in dimension

sarfaraz_sheikh — Fri, 17 Apr 2015 06:23:32 GMT

If know the solution then it would be much appreciable .......

Sarfaraz