Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Country States Rate
India Delhi 5%
India Mumbai 10%
India Kerala 3%
To something like below in a pivot or straight table
India Rate
Delhi 5%
Mumbai 10%
Kerala 3%
Hi,
It is not possible in Qlikview, the alternative solution for this layout you can use Pivot Table
Dimensions : Country, State
Expression: Only(Rate)
Please find attached file, at most this is possible.
Hope this helps you.
Regards,
Jagan.
Jagan,
Country and State are two columns in your pivot. What I want is under India, same column want to bring the cities or states. how can I do that?
you should use hierarchy's then make Hierarchy's
ankit,
how to use hierarchy's before making Hierarchy's?
Hi Gautham,
This is not possible.
Regards,
Jagan.
mistakenly wrote that i mean to say check if Hierarchy's can solve your problem
Hi Gautham,
It may not be the correct solution but I give it a try.
Hi,
Please find attached file, hope it helps you.
Regards,
Jagan.
Hi Gautham,
Pivot table is the closest option you can use , getting the data with the same column is not possible
This is my example