topic Using hierarchy data in set analysis? in QlikView

Using hierarchy data in set analysis?

Tue, 25 Aug 2015 18:56:14 GMT

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

Re: Using hierarchy data in set analysis?

kkkumar82 — Wed, 26 Aug 2015 05:47:18 GMT

Hi,

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

Hope it solves the problem.

Thanks

Kiran Kumar

Re: Using hierarchy data in set analysis?

jonathandienst — Wed, 26 Aug 2015 06:21:26 GMT

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?

Re: Using hierarchy data in set analysis?

Wed, 26 Aug 2015 10:47:31 GMT

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.

Re: Using hierarchy data in set analysis?

kkkumar82 — Wed, 26 Aug 2015 12:14:36 GMT

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

Re: Using hierarchy data in set analysis?

Wed, 26 Aug 2015 12:22:25 GMT

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

Re: Using hierarchy data in set analysis?

kkkumar82 — Wed, 26 Aug 2015 12:25:15 GMT

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

Re: Using hierarchy data in set analysis?

kkkumar82 — Wed, 26 Aug 2015 12:32:12 GMT

Yes

Re: Using hierarchy data in set analysis?

kkkumar82 — Wed, 26 Aug 2015 13:02:09 GMT

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

Re: Using hierarchy data in set analysis?

Wed, 26 Aug 2015 13:18:28 GMT

Kiran,

There is no file that I can open.

Thanks,

Frank

Re: Using hierarchy data in set analysis?

kkkumar82 — Wed, 26 Aug 2015 13:29:57 GMT

Hi ,

I attached a qvw file. Ok I will do it once again.

Thanks

Kiran Kumar

Re: Using hierarchy data in set analysis?

Wed, 26 Aug 2015 14:29:44 GMT

I believe I will re-ask my question. I have a field with 50+ non-repeating values. How can I create a dimension in a chart that uses just 2 or 3 values from that field?

Re: Using hierarchy data in set analysis?

kkkumar82 — Wed, 26 Aug 2015 19:10:09 GMT

Hi,

I think you can use Dimension Limit.

Thanks

Kiran Kumar