topic Hierarchy Issue(Tree Structure) in QlikView

Hierarchy Issue(Tree Structure)

Mon, 23 Jan 2012 08:11:22 GMT

Hi All,

I have a intersting requirement i.e. i have to display the data in Hierarchy view(Tree Structure) like

B C

D E F G

Here i have attached my sample file and xl file also. I have requirement

1) If you select Austrila from list box in Hierarchy structure we dnt have data for City listboxes for both side then those listboxes should disappear (wheneevr we dnt have the data for any list box that should disapper) and suppose we dnt have data for Region either left or right side from hierarchy that list box should disappear and the arrow has directly point to State list box.

2) Based on a Column am dividing the whole structure into 2 parts(left, Right) but in my report am not able to get that correctly am getting same data for both sides for this am using a condition like this""=If((Type ='Region') & (LOC ='Left'),Trim(Desc))"".

So please help me to get out of this

Hierarchy Issue(Tree Structure)

stephencredmond — Mon, 23 Jan 2012 10:48:03 GMT

Hi,

I would use sets to show/hide the list boxes (Layout tab, Show, Conditional). For example:

=Count({<Type ={'City'}, LOC ={'Left'}>} Desc)

This will hide the left City box if there are no cities.

Does that help you get started?

Regards,

Stephen

Hierarchy Issue(Tree Structure)

Mon, 23 Jan 2012 11:05:42 GMT

Hi Stephen,

Thank you very much for your replay its working perfectly and how to hide the arrow also.

suppose for regions list box if we dnt have entries for that,, that list box should hide and the arrow has directly point to state list box how can we do this????

Regards,

Anil

Hierarchy Issue(Tree Structure)

stephencredmond — Mon, 23 Jan 2012 11:12:07 GMT

Hi Anil,

You can't change the arrow direction. The solution is to have two arrows. One shows for one condition and the other shows for the other condition.

Regards,

Stephen

Hierarchy Issue(Tree Structure)

Mon, 23 Jan 2012 11:20:45 GMT

Hi Stephen,

Is my requirement is not possible in QV? and i dnot understand what do you mean by two arrows? and how to show them?

From my original post can you give me any ideas for my second point....

Regards,

Anil

Re: Hierarchy Issue(Tree Structure)

stephencredmond — Mon, 23 Jan 2012 11:36:21 GMT

Hi Anil,

No, it is possible. The complex way would be to write some VBScript to change the orientation and size of the arrow.

The simple way is to have different arrows. In your example, I would keep the two arrows that point from Country-Region and Region-State. However, if region has no values, hide these two (using the same method as above for hiding the List Box).

You will also have a third arrow that points directly from Country-State. However, if there are regions, this arrow is hidden. When there are no regions, you show this arrow.

Example attached.

Regards,

Stephen

Re: Hierarchy Issue(Tree Structure)

Mon, 23 Jan 2012 11:46:12 GMT

Perfect Stephen thanxx alot

My last issue is

In my Hierarchy for left side and right side i have to show different data but am getting same data for both sides

below is the example

Based on a Column(Loc) am dividing the whole structure into 2 parts(left,Right) but in my report am not able to get that correctly am gettingsame data for both sides for this am using a condition(Properties-> General-> filed expression) like this""=If((Type ='Region') & (LOC ='Left'),Trim(Desc))"".

Regards,

Anil

Hierarchy Issue(Tree Structure)

stephencredmond — Mon, 23 Jan 2012 11:55:51 GMT

Hi Anil,

Like I said above, you should probably use a set for this. For example:

=Count({<Loc={'Right'}>} Desc)

Gives me a result of 21 on the cleared document while:

=Count({<Loc={'Left'}>} Desc)

Gives me 11.

You should also realise that your expression for your list boxes is incorrect. You need to replace & with AND. The field "LOC" should also be replaced with "Loc" as field names are case sensitive.

Regards,

Stephen

Re: Hierarchy Issue(Tree Structure)

Mon, 23 Jan 2012 13:20:23 GMT

Thnx Stephen for your answers

This conditon =Count({<Loc={'Right'}>} Desc) is giving a syntax error but i have changed my previous condition as you said, like this =If((Type ='State') and (Loc ='Left'),Trim(Desc))

now its working perfectly thnx

But am wondering that in my live application am using the same condition like

=If((N_ITEM_TYP ='ACE') and (C_LOC ='ODD'),Trim(X_ITEM_VAL))

there am not geting any records simply getting empty list box,, if i replace AND with & then its not showing the correct data, any ideas for this???

Regards,

Anil

Re: Hierarchy Issue(Tree Structure)

Tue, 24 Jan 2012 09:13:04 GMT

Thanx a lot Stephen,

I have changed my condition also =If((Type ='Region') and (Loc ='Left'),Trim(Desc)). now its giving correct result

I have tried with this conditoin =Count({<Loc={'Right'}>} Desc) as you said but its showing a error in syntax it self.

Regards,

Anil

Hierarchy Issue(Tree Structure)

stephencredmond — Tue, 24 Jan 2012 09:48:54 GMT

Hi Anil,

That expression doesn't show any error in Syntax for me. It also returns values.

What version are you using? I was using v10 but have testing in v9 and v11 and see no issues.

Regards,

Stephen

Re: Hierarchy Issue(Tree Structure)

Tue, 24 Jan 2012 10:00:28 GMT

Even am using QV10

anyway i got the result by using this

=If((N_ITEM_TYP ='ACE') and (C_LOC ='ODD'),Trim(X_ITEM_VAL)) is it correct way?

Stephen i have another new issue........ is there any object other than list box to display the values on selections, because in my report i want to update that Hierarchy based on selections from list box. Am using listboxes for displaying the data but in list box am getting spaces before or after the values please see the attached screen shot for you refernce how to avoid the blank spaces?

Regards,

Anil

Re: Hierarchy Issue(Tree Structure)

stephencredmond — Wed, 25 Jan 2012 11:58:35 GMT

Hi Anil,

I am not sure what other control might suit what you want to do. Even if you Trim the values, the list box will size to whatever is correct to display the data it has in the confies of the size of the control.

I wonder if there is an easier way - maybe revisit the actual requirement (remember, the business requirement is not what should be on the screen - it is the information that they need) and think about a simpler way of displaying it?

Regards,

Stephen

Re: Hierarchy Issue(Tree Structure)

Wed, 25 Jan 2012 13:28:48 GMT

Hi Stephen,

Please look in to this post about my issue.

http://community.qlik.com/message/185100#185100

In my hierarchy I have added one more arrow Country->State how to hide the arrow when Region is present and how to show when Region is Hide....I have attached the sample file

Re: Hierarchy Issue(Tree Structure)

Fri, 27 Jan 2012 09:11:40 GMT

Hi Stephen,

=Count({<Type ={'City'}, LOC ={'Left'}>} Desc) can we use this same Set expression for QV10 and QV9

Because it is working for QV10 but it is not working in QV9

In QV9 once i applied this condition the list box is hidden but that list is having data for other selections in this case am not getting that list back in my report

Re: Hierarchy Issue(Tree Structure)

stephencredmond — Fri, 27 Jan 2012 09:29:10 GMT

Hi,

I wouldn't expect to see a difference in this data from v9 to v10.

Regards,

Stephen

Hierarchy Issue(Tree Structure)

Fri, 27 Jan 2012 09:56:49 GMT

Ok thnx Stephen but I am wondering that why it is not working in v9!!!

could you please provide me the soultion/ Set expression for my earlier post( how to show and hide third arrow) there i have attached my Test file also?

Regards,

Anil

Hierarchy Issue(Tree Structure)

stephencredmond — Fri, 27 Jan 2012 11:15:47 GMT

Hi Anil,

I am not 100% sure what you are looking for here. Probably you just need to extend what you have. Just think carefully about what the logic will be for the visibility.

Regards,

Stephen