topic Re: Calculated Dimension in QlikView

Calculated Dimension

zagzebski — Fri, 17 May 2013 15:58:24 GMT

This seems like it should be simple.

I need to create a a product straight table with many different expressions.

We have many products but the user is requesting that only one of the products shows up in this table (dimension). I realize just selecting that Product from a list box is the easy way but he is trying to get it so you don't even have to make a selection. So product A is the only one that ever shows up in this table...and the expressions just follow suit.

Re: Calculated Dimension

Gysbert_Wassenaar — Fri, 17 May 2013 16:03:37 GMT

You can change the expressions a bit so only results for product A are shown. For example sum(sales) becomes sum( {$<product={'A'}>} sales). That's the most straight forward way to achieve this imho.

Re: Calculated Dimension

zagzebski — Fri, 17 May 2013 16:24:37 GMT

Tthanks for the response. I figured I might have to go through the expression. Just thought there might be a simpler way of just doing it one time in the dimension instead of having to incorporate that set analysis into every expression. then if there is a change each one of the expressions has to be updated.

Re: Calculated Dimension

Gysbert_Wassenaar — Fri, 17 May 2013 16:30:54 GMT

You could use a variable in the expressions: vProduct. The expression would become sum({$<product={'$(vProduct)'}>}sales). You'll only have to change to variable.

Of course you could also use a calculated dimension instead like if(product = 'A', product) and check the option Suppress When Value Is Null for that calculated dimension.

Re: Calculated Dimension

zagzebski — Fri, 17 May 2013 17:49:14 GMT

That works perfect. thanks