Add expression only when other expression exists

Mon, 22 Oct 2012 14:15:03 GMT

Hi!

I've created a straight table with a number of dimension and one expression. I now wan't to add a second expression (or dimension) which should be visible only when the furstexpression has a value in that column. If I add this dimension as a dimension or an expression, it is going to att rows to the table where the first expression has no value.

A little illustration.

Before:

Product	Category	Sum(sales)
shirt	clothes	50
bag	accessories	100
pants	clothes	75
shorts	clothes	30
jacket	outerwear	80

After:

Product	Category	quantity	Sum(sales)
shirt	clothes	5	50
bag	accessories	1	100
pants	clothes	5	75
shorts	clothes	3	30
jacket	outerwear	1	80
hat	accessories	4
shoes	shoes	7

So Sum(Sales) is my first expression and quantity is my second. I don't want to show the rows where Sum(sales) is null. Is there an easy way to do this?

Re: Add expression only when other expression exists

shree909 — Mon, 22 Oct 2012 15:12:26 GMT

Hi ,

this can be done by writing an isnull operation for quantiry, if(isnull(sum(sales) = not null,quantity)

try this

Re: Add expression only when other expression exists

jeffmartins — Mon, 22 Oct 2012 15:46:22 GMT

Hi kimlindell,

You can use quantity expression as if(sum(sales) > 0 ,sum(quantity))

See the attached file

Regards

topic Re: Add expression only when other expression exists in QlikView

Add expression only when other expression exists

Re: Add expression only when other expression exists

Re: Add expression only when other expression exists