topic Re: Select in Hierarchy in QlikView

Select in Hierarchy

Tue, 05 Mar 2013 19:38:15 GMT

Hi All,

Need one help. I have a hierarchy with 5 dimension. This hierarchy is used in a straight table.

is there a way to dynamicaly have a calculated dimension populated with field values of the current level of the hierarchy?

So if I am at Dim3 level in the hierarchy, the calculated dimension should have the values of Dim 3 field.

I was trying to use getFieldSelections(getCurrentField(ProductHierarchy)) but it does not work. Any thoughts please?

Thanks

Raghu

Re: Select in Hierarchy

kaushiknsolanki — Wed, 06 Mar 2013 08:59:08 GMT

Dear Raghu,

Kindly post example file for more clarification.

Regards,

Kaushik Solanki

Re: Select in Hierarchy

Gysbert_Wassenaar — Wed, 06 Mar 2013 08:59:21 GMT

Is there a reason you can't use a Drill-down group? You can create groups on the Dimensions tab of the properties window. Add the dimensions that make up your hierarchy to the group and use the group as a dimension in your chart. If you click on a value in the group dimension the chart will drill down to the next level of the hierarchy.

Re: Select in Hierarchy

Wed, 06 Mar 2013 18:34:19 GMT

Hi Gysbert,

you are right in this approach. However I was trying to achieve a different functionality. I do not want the chart to be drillable, but the straight table should be drillable and use the drill group.

Hence I wanted to set the bar chart dimension based on the level of drill down group dynamically. Hope I was able to elaborate correctly.

Thanks

Raghu

Re: Select in Hierarchy

Gysbert_Wassenaar — Wed, 06 Mar 2013 19:48:42 GMT

See attached qvw. Is that what you're talking about?

Re: Select in Hierarchy

Wed, 06 Mar 2013 19:58:03 GMT

Thanks Gysbert.

Thats exactly what I wanted

I have one question for you:

=$(=GetCurrentField(MyGroup))

I get the GetCurrentField(MyGroup) piece of code. But why were we required to put the $(= before that. Will it not evaluate directly without that? I assume that all functions evaluate directly.

Or I am missing something very basic here?

Thanks

Raghu

Re: Select in Hierarchy

Gysbert_Wassenaar — Wed, 06 Mar 2013 20:04:01 GMT

If you use =GetCurrentField(MyGroup) then the name of the field is used as value instead of as field name for the dimension. It's not very basic, so don't worry about missing something. I first tried without the $(= too. I saw what happened and tried using dollar-expansion next. That did gave me the result I wanted.

Re: Select in Hierarchy

Wed, 06 Mar 2013 20:06:10 GMT

great..thanks Gysbert!