topic Re: Custom Table in QlikView

Custom Table

Mon, 09 Nov 2015 07:07:14 GMT

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.

Re: Custom Table

Anonymous — Mon, 09 Nov 2015 07:12:01 GMT

What is the criteria to define this:

Medium-to-small rate,

Small-to-Large rate,

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

Re: Custom Table

Mon, 09 Nov 2015 07:43:32 GMT

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

Re: Custom Table

Anonymous — Mon, 09 Nov 2015 08:16:14 GMT

Could you share the logic?

Re: Custom Table

Mon, 09 Nov 2015 08:22:32 GMT

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%

Re: Custom Table

Anonymous — Mon, 09 Nov 2015 08:37:28 GMT

This is what we can do..

PFA..

Re: Custom Table

Mon, 09 Nov 2015 09:14:21 GMT

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

Re: Custom Table

Mon, 09 Nov 2015 10:15:44 GMT

I got The Solution . Thanks To Every One

Re: Custom Table

Kushal_Chawda — Mon, 09 Nov 2015 10:25:58 GMT

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

Re: Custom Table

Mon, 09 Nov 2015 10:58:44 GMT

Thanks Kush141087 ,

Please find the attachment above