Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I have an uncommon requirement where in I need to show values from different fields as single Dimension in straight/pivot table and it's corresponding values as expression.
Now comes the tricky part, those different fields are hierarchy fields .
Example fields.
Nation,
State,
District
Now I want , if one particular district is selected, only the corresponding state should appear along with nation in the table dimensions.
Let's say, I selected District B, and that district belongs to State B, now the table should appear something like this,
Dimension, expression 1, expression 2
Nation, nationsvalues......
StateB, stateB's values...
District B, District B's value
Also, state and district should appear only when the selection is made or only one possible value
Any ideas or suggestions are really highly appreciated.
@jagan @sunny_talwar @henric_cronstrom
Not sure but in these situations generic load is one of the possibility, you may need to expore on that -
https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470