topic Re: multiple distinct expressions in 1 chart issue in QlikView

multiple distinct expressions in 1 chart issue

Mon, 12 Oct 2015 13:00:10 GMT

Hi all,

Attached is a qvw with a sample data set.

I'm trying to do 2 distinct counts on the field and for some reason I get 0 on one of them when actually it should have a number.

why is that?

the selection I'm making is: Date = January

you can see that the exposures unique is correct but the responders unique is not.

why is that?

Thanks,

Boris

chaper — Mon, 12 Oct 2015 13:13:11 GMT

Did you tried Set analysis??

chaper — Mon, 12 Oct 2015 13:15:28 GMT

Check the attached app.Let me know whether it works or not?

Mon, 12 Oct 2015 13:17:59 GMT

Thanks, works.

but shouldn't the if clause handle it?

Mon, 12 Oct 2015 13:23:45 GMT

You can't use the Aggregation function inside of IF. Please find the attached qvw. I wrote both IF & set Analysis expressions.

IF Cond:

Inventor : =Count(DISTINCT if(invited=1,subkey))

Responder : =Count(DISTINCT if(responder=1,subkey))

Set Analysis:

Inventor : =Count({<invited={1}>}DISTINCT subkey)

Responder : =Count({<responder={1}>}DISTINCT subkey)

chaper — Mon, 12 Oct 2015 13:31:46 GMT

FYI