topic Re: Always 1 selected and Search in QlikView

Always 1 selected and Search

Wed, 04 Jun 2014 16:32:04 GMT

I have a qlikview tool that allows the user to search by either "Account Name" or "Account ID".

The amount of data has gotten to the point, that I want to make sure that always 1 is selected (either or/ or both).

When I make "Account Name" always 1 selected. Then you can no longer search on Account ID, any value that comes up is greyed out, and when selected, it doesn't overwrite current value. And vice versa with "Account ID"

For instance (see attached example)

Account Name = Beth is selected, which corresponds with account ID = 2.

Account Name is a "always one value selected field"

If someone searches for account ID = 6 (which is frank) I want them to be able to select it, and have it choose frank automatically.

Thanks for your help in advance!

Re: Always 1 selected and Search

Wed, 04 Jun 2014 16:44:49 GMT

there might be different ways .... below is one way

in script:

load AccountName,AccountID,dual(AccountName,AccountID) as Account;

load AccountName,AccountID from .... ;

in the app:

use the Account field for both text boxes one with text refresentation for account name another with expression num(Account) for accountid

Re: Always 1 selected and Search

alexandros17 — Wed, 04 Jun 2014 16:49:34 GMT

try this ...

Re: Always 1 selected and Search

maxgro — Wed, 04 Jun 2014 17:17:19 GMT

perhasps with some trigger on the fields

see attachment

Re: Always 1 selected and Search

Wed, 04 Jun 2014 17:25:49 GMT

Please check the trigger on - Account Name "on select".

Re: Always 1 selected and Search

Wed, 04 Jun 2014 18:07:08 GMT

I am able to clear all filters, which is the issue.

The real document I'm working with has too much data to allow all values to be cleared.

I need to have the always one selected checkbox clicked for Account Name.

Re: Always 1 selected and Search

Wed, 04 Jun 2014 18:11:08 GMT

I am able to clear all filters, which is an issue. The document I'm working with is too large for every account to be available, so I need to have the Always Select One checkbox active on Account Name. When I turn that functionality on, the trigger stops working.

Re: Always 1 selected and Search

Wed, 04 Jun 2014 18:12:05 GMT

I need to have the Always select one checkbox active on Account Name, as there is too much data in my real tool, if they decide to clear all. Once I add the functionality of always select one, then the trigger stops working.

Re: Always 1 selected and Search

Wed, 04 Jun 2014 18:20:17 GMT

You dont have to make it "always one selected value", you can make that happen by using a trigger "on select" of account name, so even if u try to clear account name there will be only one selected value.

Re: Always 1 selected and Search

Wed, 04 Jun 2014 18:23:41 GMT

Hi, sorry, I'm new to triggers. In your example, I am able to "clear all". Can you help me fix your example, so the functionality works, and they cannot clear all the filters?

For instance, open up your document, and then search for account 6. After selecting it, hit clear all.

Re: Always 1 selected and Search

maxgro — Wed, 04 Jun 2014 18:26:26 GMT

how did you clear all filters?

the triggers replace the "always one....."

"always one....": I suppose you can't have account id and name both with "always one...." checked

my 2 ideas were

- trigger

- replacing the 2 fields with a AccountID & '-' & AccountName

Re: Always 1 selected and Search

Wed, 04 Jun 2014 18:45:48 GMT

not discouraging but triggers would be last thing i will choose to fix any issue, because it causes unnecessary issues.

Re: Re: Always 1 selected and Search

Wed, 04 Jun 2014 18:45:52 GMT

Check now pls.

Re: Always 1 selected and Search

Wed, 04 Jun 2014 18:49:03 GMT

But sometimes you have to rely on triggers to fix issues. I think it depends on the complexity of the issue and whether you have any other option available. In our company we are working on complex disjoint datasets which we have to link together and the only option we have is to send triggers back and forth and we do use some very complicated triggers .They work well. In my opinion as long you understand the triggers well, it should work as it is supposed to.

Re: Always 1 selected and Search

Wed, 04 Jun 2014 19:02:15 GMT

agreed, just saying if there is other solution available why triggers.

that trigger solution might cause issue when you have other field (accountAddress) in the same account table and do select / unselect accountAddress will clear account name.

Re: Re: Always 1 selected and Search

Wed, 04 Jun 2014 19:20:02 GMT

In thecondition you have given above, the below attachment should work. There is only one trigger her "On any select" and it always goes back to Account Name no matter what you selected and cleared.

The logic is if there is nothing selected at all then it defaults to accountname. Even if u have another field eg:accountaddress and you do a select on that and then you unselect it, it goes back to the accountname.

Re: Re: Re: Always 1 selected and Search

Wed, 04 Jun 2014 19:21:09 GMT

this one is better.

Re: Always 1 selected and Search

Wed, 04 Jun 2014 20:10:18 GMT

Hi, that seemed to work, but then I encountered a problem. (in real tool)

I removed the "Always Select One" checkbox and added the trigger function.

I attempted to "clear all" and it worked and went to my default selected account.

However, when I then searched for a new account, it froze up the entire tool.

It behaved the way it would, if no account was selected.

With the "Always Select One" box checked, it does not ever "freeze up".

Re: Always 1 selected and Search

Wed, 04 Jun 2014 20:16:38 GMT

That is wierd. I have used more complex trigger with a big dataset and it never happened. How big is your file?

There is a more simple way to do the same thing, but not sure if u r looking for more functionality with it. Select a default accountname and then on the clear button make it "Set clear state". No matter what u choose when u clear it , it always sets it back to that default accountname. Let me know if this helps.

Re: Always 1 selected and Search

Wed, 04 Jun 2014 20:49:00 GMT

Hello again, and thank you for all your help.

I think the latest solution with a "set clear state" might be the simplest and therefore most elegant solution. They still can accidentally remove the filter (by using eraser on account name, or clicking the highlighted account name), which will cause the tool to freeze, but I will reinforce in training that they should not...

This will also allow them to select multiple Accounts at once, which is something they were hoping to be able to do.

Thanks!