topic Re: Set analysis Previous Selection in QlikView

Set analysis Previous Selection

saumyashah90 — Mon, 10 Mar 2014 14:47:41 GMT

Hi Guyz i have

Count(Distinct Num_Employee)

and i want previous selection for this

i tried using

Count({$1} Distinct Num_Employee)

but its not working.

Can anyone please suggest me solution, better if it is set analysis

Re: Set analysis Previous Selection

Anonymous — Mon, 10 Mar 2014 14:53:45 GMT

try count(Distinct {$1} Num_Employee)

Re: Set analysis Previous Selection

saumyashah90 — Mon, 10 Mar 2014 14:56:10 GMT

nope thanks...already tried...

Re: Set analysis Previous Selection

srchilukoori — Mon, 10 Mar 2014 15:03:40 GMT

Both the expressions work as in the attached app.

Count({$1} Distinct Num_Employee)

count(Distinct {$1} Num_Employee)

The reason for the error could be because of no previous selections.

Re: Set analysis Previous Selection

Anonymous — Mon, 10 Mar 2014 15:04:14 GMT

works on my end...what error or result do you get?

Re: Set analysis Previous Selection

saumyashah90 — Mon, 10 Mar 2014 15:06:06 GMT

Error can make some problem...can you put this in set analysis and let me know?

Re: Set analysis Previous Selection

srchilukoori — Mon, 10 Mar 2014 15:13:23 GMT

have you check the app. Yours and jsaradhi's expressions are working fine.

Re: Set analysis Previous Selection

saumyashah90 — Mon, 10 Mar 2014 15:41:32 GMT

Syntax Error.... Red line under the curly bracket

Re: Set analysis Previous Selection

jaimeaguilar — Mon, 10 Mar 2014 17:18:24 GMT

Hi,

Not having a previous selection should not give an error, it just results in Zero value. As you said, both expressions should work as expected. If syntax is underlining some part of the formula then it may be something else,

regards

Re: Set analysis Previous Selection

Anonymous — Mon, 10 Mar 2014 21:51:09 GMT

Red line under curly bracket doesn't always mean the expression is not correct. Not having a previous selection should not throw an error.