topic Re: set analysis and variable in QlikView

set analysis and variable

Fri, 28 Sep 2012 13:12:45 GMT

Hello everyone,

Well I get an issue, and I've been woking on it since yesterday, and it's starting to give me a headache....

Here's the thing :

I've got a table with 2 columns :

LOAD * INLINE [

ID, SALARY

1,1234

2,4567

3,5467

4,904

5,3456

6,2123

];

I created a variables which is $(median) = (max(SALARY)-min(SALARY))/2

Now I want to count how many id's which have a salary over and below this variable

I tried :

count({<SALARY={">$(median)"} >}distinct ID) -> It's not working.
count({<SALARY={' >$(median)'} >}distinct ID) -> It's not working either. (simple quote)

I've tried many more things I saw in the forum, but no conclusive results.

I really need eveyone's help,

Wish you all the best,

Will

Re: set analysis and variable

MayilVahanan — Fri, 28 Sep 2012 13:20:07 GMT

Try like this

variable name -> median = (max(Salaray)-min(Salary))/2;

count({<SALARY={">$(median)"} >}distinct ID)

Hope that helps

Re: set analysis and variable

Gysbert_Wassenaar — Fri, 28 Sep 2012 13:35:12 GMT

I've used this: sum(if(SALARY > $median ,1,0))

see attached file

Re: set analysis and variable

Fri, 28 Sep 2012 13:39:21 GMT

Nope, this doesn't work at all. the text box returns 0, please see attached files

Re: set analysis and variable

Fri, 28 Sep 2012 14:00:32 GMT

You forgot to put a '=' before the calculation ( (max(SALARY) - min(SALARY) ) / 2 )

Re: set analysis and variable

Fri, 28 Sep 2012 14:24:57 GMT

but you get the same results if you put in the first textbox

=median instead of =$(median_textbox)

Re: set analysis and variable

Gysbert_Wassenaar — Fri, 28 Sep 2012 14:32:45 GMT

great. thanks for that bit of info.

Re: set analysis and variable

Anonymous — Fri, 28 Sep 2012 15:04:23 GMT

You can simply:

initialise the variable :

median=(Max(SALARY)-Min(SALARY))/2

and calculate:

=count(if(SALARY>median,SALARY))