Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using hierarchy data in set analysis?

I have a chart that uses hierarchy data. I would like the chart to maintain  two hierarchy/treeview items (Interest Income, Fee income,etc...) and have have the ability to change around regions (Which is also in a hierarchy/treeview, North, Northeast,etc...). I have the hierarchies in drill down groups also. Is there any way to do set analysis like Sum(${<measurement={Current hierarchylevel}>}Amount)?

If this is posted to the wrong place, please advise what place to send this to.

Thank You,

Frank

12 Replies
kkkumar82
Specialist III
Specialist III

Hi,

Sum(${<measurement={getcurrentfield(drilldowngroupname)}>}Amount)



Hope it solves the problem.


Thanks

Kiran Kumar

jonathandienst

Your high level requirement is clear, but the details are not clear. Please post your qvw or a represntative sample to and a more detailed explanation of what you require. For example, how should the set expression filter the data differently as you drill into the hierarchy?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Sorry for the lack of detail, Jonathan.  It is an extremely large file. I am thinking about using a calculated dimension. IThe dimension would be the drill down group. The expressions would be the Sum of the current year, sum of previous year, monetary difference between current and previous year, and the percentage of the difference.  I want the expressions to be static with the dimension selecatble from a separate list box.

What you have Kiran is great but I do not need a Sum, since it would be a dimension.

THank you both for the responses.

kkkumar82
Specialist III
Specialist III

Hi,

I can help you on this, I had a same situation , I had ten charts where there are 3 expressions and 8 Dimension groups rather than creating 8 charts I created a variable dimension (which is calculated) and I had a input box with all the group names and when I select a value in the list box the chart will change to the group.

Is that what you required

Thanks

Kiran Kumar

Not applicable
Author

Kiran, this looks like what I might be after. To reiterate, create a variable that will hold the selections from a list box and use the variable as the dimension in the chart. Is that correct?

Thanks,

Frank

kkkumar82
Specialist III
Specialist III

Create a inline load(Data island)

as below for eg

Load * inline [

SNO, Group Name, Group Title

];

Now in the front end create a variable as vDynamicGroups

Next create a input box and add the above variable.

In the input box properties, goto Constraints->tab

See the attached pic and select the options like that

and for the concat function, concat(Group Name,SNO)

and lastly use the variable (vDynamicsGroups) in the chart.

Thanks

Kiran Kumar

kkkumar82
Specialist III
Specialist III

Yes

kkkumar82
Specialist III
Specialist III

PFA qvw file , I created three dimension groups and a input box for holding all those groups, check out the example. Let me know any modifications required.

Thanks

Kiran Kumar

Not applicable
Author

Kiran,

There is no file that I can open.

Thanks,

Frank