topic Re: Adding Calculated Content in particular Dimension in QlikView

Adding Calculated Content in particular Dimension

sarfaraz_sheikh — Mon, 13 Apr 2015 11:02:54 GMT

Dear All,

I have one user requirement like below,

As of now the chart is looking like below :-

However I want my chart to appear like below..one more conversion field i want immijiate next to ISales_Closed_Final.

Calculation for Conversion ........

ATotal_Leads_Considered ISales_Closed_Final Conversion

Amount=197457 Amount=177247 177247 / 197457 = 89.76

Count=28 Count=25 25/28 *100 =89.28

Is this possible in above pivot chart ....Because all the columns in Blue colour are the dimensions content ...at dimension level how i can calculate percentage between two fields ...

Is there any way if yes the solution would be much appreciable .... There is requirement like this from user...

Sarfaraz

Re: Adding Calculated Content in particular Dimension

sarfaraz_sheikh — Mon, 13 Apr 2015 11:37:10 GMT

kindly reply if solution is possible .............suggest any way to do it.

Sarfaraz

Re: Adding Calculated Content in particular Dimension

Anonymous — Mon, 13 Apr 2015 12:37:38 GMT

Given that the columns are the values of the Status_Description field, and there is no value 'Conversion' - you have to add it in the script, and calculate right there.

Re: Adding Calculated Content in particular Dimension

sarfaraz_sheikh — Mon, 13 Apr 2015 12:47:51 GMT

Dear Michael,

Your are right ....same is my concern ......I tried that but failed to add conversion field in that.

Kindly suggest me how i can add that field with calculation .......

sarfaraz

Re: Adding Calculated Content in particular Dimension

sarfaraz_sheikh — Mon, 13 Apr 2015 13:45:19 GMT

Dear @ hic / Michael,

Please reply on it .....stuck in the problem ........

Sarfaraz

Re: Adding Calculated Content in particular Dimension

sarfaraz_sheikh — Tue, 14 Apr 2015 06:26:46 GMT

Dear Community,

any clue to achive the above requirement .........I tried but failed any alternate way i can try

kindly help ..

Sarfaraz

Re: Adding Calculated Content in particular Dimension

Anonymous — Tue, 14 Apr 2015 16:14:49 GMT

I found time to try. See expressions for Amount and Count. I ddin't touch Leads, left it for you...

I had to add 'Conversion' value tio the Status_Description field, and the relevant data, I called it SumTotal, sumclosed (For Amount calculation) and LEAD_NO_Total, LEAD_NO_Closed (for the counts).
See the script., hope it helps. Probably there are better solution, but I've spent more time on this than I intended to...