textbox expression with hierarchy

Thu, 15 Sep 2011 15:57:19 GMT

Hi,

I want to display a picture in a textbox. I do it perfectly with the following expression when something is selected in the field [TimeHierarchy].[Year]:

=if(

Sum({$<"[TimeHierarchy].[Year].[MEMBER_CAPTION]"={$(#=Only("[TimeHierarchy].[Year].[MEMBER_CAPTION]"))}>}"[Measures].[Energy]")

Sum({$<"[TimeHierarchy].[Year].[MEMBER_CAPTION]"={$(#=Only("[TimeHierarchy].[Year].[MEMBER_CAPTION]")-1)}>}"[Measures].[Energy]")

> 0,

'qmem://<bundled>/BuiltIn/arrow_ne_r.png',

if(

Sum({$<"[TimeHierarchy].[Year].[MEMBER_CAPTION]"={$(#=Only("[TimeHierarchy].[Year].[MEMBER_CAPTION]"))}>}"[Measures].[Energy]")

Sum({$<"[TimeHierarchy].[Year].[MEMBER_CAPTION]"={$(#=Only("[TimeHierarchy].[Year].[MEMBER_CAPTION]")-1)}>}"[Measures].[Energy]"))

< 0,

'qmem://<bundled>/BuiltIn/arrow_se_g.png',

'qmem://<bundled>/BuiltIn/arrow_e_y.png'

)

Now the problem is that if I select something in the next level of the TimeHierarchy: [TimeHierarchy].[Month], I want the conditions to depend on the selected month (itself in the selected year).

In other word, I would like to display the image according to the lowest level of the hierarchy that's activated in my sheet.

I tried some stuffs that didn't work.

Thanks in advance for your advices.

textbox expression with hierarchy

Wed, 21 Sep 2011 14:03:56 GMT

Anybody with a beginning of solution?

topic textbox expression with hierarchy in QlikView

textbox expression with hierarchy

textbox expression with hierarchy