topic Re: Flag cannot be cleared from selection in QlikView

Flag cannot be cleared from selection

Wed, 17 Feb 2016 09:00:16 GMT

Hi,

I have a listbox that has an expression like below

if(%spendFlag = 1, Region)

The listbox is only showing regions that has a %spendFlag = 1. The problem is that if I select any region from the listbox, I cannot select any other regions in other sheets. one reason is that If don't use the hide prefix, I can see in the selection box that along with regions, I also see the %spendFlag=1 in the selection box. If I use a trigger to clear the field %spendFlag upon leaving the sheet, it cannot clear %spendFlag and without clearing this field, I cannot select other regions on other sheets. I can only select the regions where %spendFlag = 1

Any solution for this?

Re: Flag cannot be cleared from selection

MK_QSL — Wed, 17 Feb 2016 09:05:34 GMT

Can you provide sample file for this?

Re: Flag cannot be cleared from selection

senpradip007 — Wed, 17 Feb 2016 09:06:09 GMT

Use a trigger on "Leave Sheet", clear the field of Region and %spendFlag.

Re: Flag cannot be cleared from selection

sasikanth — Wed, 17 Feb 2016 09:31:50 GMT

HI,

Try this expression

=Aggr(Only({<%spendFlag={'1}>}Region)Region)

=Aggr(Only({<%spendFlag={'1'}>}Region),Region)

Also use the trigger Clear All on leave sheet and reset the clear state (Selection-->Reset Clear state ) if enabled

Re: Flag cannot be cleared from selection

senpradip007 — Wed, 17 Feb 2016 09:44:29 GMT

Sunny,

Expression may be like, Aggr(Only({<%spendFlag={1}>}Region)Region)

Re: Flag cannot be cleared from selection

tresB — Wed, 17 Feb 2016 09:56:51 GMT

One more correction (comma) - Aggr(Only({<%spendFlag={1}>}Region) , Region)

Though I am not sure, if this helps the original case of query. May be a sample qvw could help us help better.

Re: Flag cannot be cleared from selection

Wed, 17 Feb 2016 10:28:59 GMT

Here is an example file. In the second sheet for example, I cannot select stockholm.

Regards

Re: Flag cannot be cleared from selection

sasikanth — Wed, 17 Feb 2016 10:38:32 GMT

HI,

PFA Added trigger

Re: Flag cannot be cleared from selection

Wed, 17 Feb 2016 10:45:51 GMT

Thanks for the solution. I cannot use the clear all trigger. I only want to clear the flag. If you use the clear field trigger, you can notice that it does not work

Regards

Re: Flag cannot be cleared from selection

sasikanth — Wed, 17 Feb 2016 10:51:59 GMT

You are making selections on City field so you should clear the city field in order to see no selections in next sheet

i dont think there is a meaning if you clear %Flag.

if i missed please explain what you are trying to achieve

Re: Flag cannot be cleared from selection

marcus_sommer — Wed, 17 Feb 2016 10:54:40 GMT

Instead of a clear-action you could use a select action in this field with a reversed logic:

= null()

which will clear any selection in this field.

- Marcus

Re: Flag cannot be cleared from selection

Wed, 17 Feb 2016 11:06:46 GMT

OK so the purpose is that I do not want the City field to be cleared. I am clearing the flag because on the next page, I want to see the current cities selected but I also want the other cities to be selectible. If the %flag =1, then we cannot select the cities where %flag=0.

Simply, on the main page, I only want the listbox to select the cities where %flag=1. On sheet 1, I also want to be able to select other cities. While doing this, I do not want to lose the cities selections while moving between sheets

Regards

Re: Flag cannot be cleared from selection

rubenmarin — Wed, 17 Feb 2016 11:12:01 GMT

One improvement (I think), to keep seeing non-selected values:

=Aggr(Only({1<%spendFlag={1}>}Region), Region)

Selections are made in the Region field, not in the spendFlag field, wich seems was the problem in the original post.

Re: Flag cannot be cleared from selection

sasikanth — Wed, 17 Feb 2016 11:23:08 GMT

HI,

i added clear %flag trigger

See attachment

Re: Flag cannot be cleared from selection

MK_QSL — Wed, 17 Feb 2016 11:25:09 GMT

Like this?