Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I got The Solution . Thanks To Every One
What is the criteria to define this:
Medium-to-small rate,
Small-to-Large rate,
as you already having Medium,Small,Large...
To know the Rate of Small to medium stock , in that to know how many small to Large stock .
Could you share the logic?
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%
This is what we can do..
PFA..
Sorry... I don't want like this. thanks for your response.
I got The Solution . Thanks To Every One
Please post the solution rather than just writing the Statement. It will help others to resolve the same kind of problem
Thanks Kush141087 ,
Please find the attachment above