topic Re: Only Function in QlikView

Only Function

Sat, 13 Jul 2013 12:09:31 GMT

Hello all,

I am trying to work out an Only function with the use of some variables instead of fields

the idea is to get the population when one selects the city and the age group

the fields are

City, <14, 15-24, 25-34, etc

and the variables are vCity and vAge,

so the user selects the city and the age group and they should get the population as a result of this function:

only({<City=vCity>} vAge), apparently this is not correct,

thanx!

Re: Only Function

kaushiknsolanki — Sat, 13 Jul 2013 12:16:03 GMT

Try this,

only(Population)

But only will work only when you have only one value for selection.

Regards,

Kaushik Solanki

Re: Only Function

Sat, 13 Jul 2013 12:39:38 GMT

thank you for the feedback, but I am a bit confused,

you see the fields are

City, <14, 15-24, 25-34, etc

and the variables are vCity and vAge,

I have to select the City ( the row via the vCity variance) and the age group (the column via the vAge variance) to get the correct value which is the population.

Am I too confusing?

thank you

Re: Only Function

kaushiknsolanki — Sun, 14 Jul 2013 06:16:57 GMT

Hi,

Kindly post your qvw file. That will be helpful to me in understanding your problem.

Regards,

Kaushik Solanki

Re: Only Function

Sun, 14 Jul 2013 07:40:52 GMT

hi, here it is

thank you!

Re: Only Function

kaushiknsolanki — Sun, 14 Jul 2013 07:46:32 GMT

Hi,

Have a look at the attached File.

Hope this is what you were trying to achieve.

Regards,

Kaushik Solanki

Re: Only Function

Sun, 14 Jul 2013 08:01:31 GMT

Thank you for the hint! very helpful,

I guess ONLY does not work with variables? or I should try approaching it otherwise?

Best regards

Re: Only Function

kaushiknsolanki — Sun, 14 Jul 2013 08:05:53 GMT

Hi,

It can work.

Have a look at the attached file.

Regards,

Kaushik Solanki

Re: Only Function

Sun, 14 Jul 2013 08:23:26 GMT

I see, I have to make the crosstable either way.

again, thank you

Re: Only Function

swuehl — Sun, 14 Jul 2013 17:53:25 GMT

Using the CROSSTABLE is probably the more QV way of doing it, selecting in fields instead of using variables to analyze your data.

But just as a note, you can do it like you initially tried:

=only({<CITY= {$(vCITY)} >} [$(vAGE)] )

Re: Only Function

Sun, 14 Jul 2013 18:02:09 GMT

Yes,

QV way is always the best way,

thank you for your comment!