Custom Table

[#1]

Hi

can any one help me on the below scenario,  I have a table with Type as a dimension it has the values

Medium,

Medium-to-small rate,

Small,

Small-to-Large rate,

Large,      in the Qlikview Table, however in the source data the field Type has 3 values, those are Medium,Small, Large.

the Medium-to-Small rate  is the ratio of Small/Medium    and also the Small-to-Large rate is the ratio of Large/Small.

how do I do it in the Qlikview straight table by using chart function or inter record functions.

please find the sample data and expected result.

[Anonymous]

What is the criteria to define this:

Medium-to-small rate,

Small-to-Large rate,

as you already having Medium,Small,Large...

[#3]

To know the Rate of Small to medium stock , in that to know how many small to Large stock . 

[Anonymous]

Could you share the logic?

[#5]

Logic:

Type                              2015 Sep

Medium                         52840

Medium-to-small rate    65%

Small                             34558

Small-to-Large rate       90%

Large                             31040

Medium-to-small rate    65%  can be obtain by calculating the   Small Value/Medium Value, Here 34558/52840 =65%

Small-to-Large rate       90%   can be obtain by calculating the  Large Value/Small Value, Here 31040/34558=90%

[Anonymous]

This is what we can do..

PFA..

[#7]

Sorry... I don't want like this. thanks for your response.

[#8 · Accepted solution]

I got The Solution . Thanks To Every One

[Kushal_Chawda]

Please post the solution rather than just writing the Statement. It will help others to resolve the same kind of problem

[#10]

Thanks Kush141087 ,

Please find the attachment above