where clause in expression

[#1]

i m new to qlikview and its my fist post......... hope i will get the solution

I have a bar chart with ITEM_NAME as dimension and SUM(QUANTIT) as expression

I want to show the unit of item in text box....

i.e

If user select any particular item from list box so apropriate unit of that item (may be more then one (e.g water can be in Liter or bottols) display on text box or any other way to do this...?

thnks alot

[swuehl · Accepted solution]

Maybe like

= if( GetSelectedCount(ITEM_NAME) = 1,

'Units of '& ITEM_NAME&' are: '& concat (distinct UNIT_NAME,' - ')

)

[#3]

thnks alot swuehl !!!

thats perfect and quick ....

further i want to know can i get the same with regular expression???

[swuehl]

Hm, can you give an example in pseudo code what you intend to do?