topic Need some help with Only and set analysis in QlikView

Need some help with Only and set analysis

Fri, 12 Sep 2014 12:40:18 GMT

Hi,

I'm using a Only function with a set analysis in variable, it looks something like this:

=only({<UserCode={$(=UserName)}>} UserSiteCode)

Username is another variable with the following code: =mid(OSUser(),13)

I display the UserSiteCode in a Text Object on the main page.

Now here is problem - when I open the model the variable is null, but as soon as I go to another sheet and then back to the main then the variable contains the correct value.

Why is it doing it?

Re: Need some help with Only and set analysis

Anonymous — Fri, 12 Sep 2014 14:59:51 GMT

Try defining your variable without the = at the beginning. Your set analysis doesn't need the = in the extension either and try using quotes too

=only ({<UserCode={'$(UserName)'}>} UserSiteCode)

Re: Need some help with Only and set analysis

Fri, 12 Sep 2014 15:38:33 GMT

Nope ... still the same. I think I must explain myself better. The variable is working fine but the problem is the variable is not populated with a value on startup - I must switch between sheets before is it is populated with the site code.

Re: Need some help with Only and set analysis

don_qlikview — Fri, 12 Sep 2014 15:42:36 GMT

Can you try writing this in your script

Let UserName = mid(OSUser(),13);

and check in the variable overview if that variable is holding the value or not.

Re: Need some help with Only and set analysis

Fri, 12 Sep 2014 16:05:03 GMT

OK, I tried the following.

I entered this into my script:

Set UserName='=mid(OSUser(),13)';

Set Site='=only({<UserCode={"#(UserName)"}>} UserSiteCode)';

Let Site = replace('$(Site)', '#', chr(36));

But still the same. As soon as I enter the model Username has it's value but Site Not? When I click on the second sheet and then back to the main tab then Site has the correct value .....

Re: Need some help with Only and set analysis

Sat, 13 Sep 2014 05:09:58 GMT

I found the problem ....

The macro where I set my selection for site was on the Sheet open trigger. When I ran the macro on the document open trigger as well all was 100% ....

Thanks all