topic Re: Writing If expresion in QlikView

Writing If expresion

Fri, 14 Nov 2014 10:00:08 GMT

I'm displaying data on chart by writing a simple expression - Avg(Population)

What should be the expression if I want to show data corresponding to following condition:

if(date<X)

Avg(Population)

That is, Avg(Population) should be calculated and shown for the dates less than X

Re: Writing If expresion

anbu1984 — Fri, 14 Nov 2014 10:04:16 GMT

if(date<Date#('1/1/2014','MM/DD/YYYY'),Avg(Population))

Re: Writing If expresion

sujeetsingh — Fri, 14 Nov 2014 10:06:37 GMT

Avg(if(date<X,Population))

You can go for set analysis

Avg({$<Date<X>}Population)

Re: Writing If expresion

Fri, 14 Nov 2014 10:17:07 GMT

By mistake I could not ask what I actually meant. I want a conditional expression for showing Avg(Population) for dates less than X.

For example, if I have population value at 3 different dates (W, X, Z), I would like to show Avg(Population) for all the dates less than X. Average value should not include population value at Z.

Re: Writing If expresion

anbu1984 — Fri, 14 Nov 2014 11:28:00 GMT

If you have only one expression, then try any of the above suggested solutions and select "Suppress zero values" on Presentation tab

Re: Writing If expresion

Fri, 14 Nov 2014 11:33:57 GMT

let vDate=date(max(date))

avg({<date={"<=$(vDate)"}>}population)

cheers,

kunal bhattacharjee