topic Re: Hiding field values in current selection box in QlikView

Hiding field values in current selection box

Mon, 23 Mar 2015 11:43:39 GMT

Hello all,

My qlikview applicaiton has 10 tabs.

I have given "Always one value selected for a field".

Out of the 10 tabs, 5 tabs should not show this selection in the current selection box, rest 5 can show this in the current selection box.

How to achieve this?

Thanks for your help,

Vidhya

Re: Hiding field values in current selection box

giakoum — Mon, 23 Mar 2015 11:46:18 GMT

create a copy of the field, use hide prefix to hide it, and use the hidden one in the 5 tabs

strange requirement

Re: Hiding field values in current selection box

Mon, 23 Mar 2015 11:49:16 GMT

hi,

Though I use, hide prefix, rest of the 5 tabs will always have one value selected.

so, it is getting reflected in rest of the tabs also.

Thanks,

Vidhya

Re: Hiding field values in current selection box

awhitfield — Mon, 23 Mar 2015 11:54:06 GMT

Can you post your app please to better illustrate the issue?

Andy

Re: Hiding field values in current selection box

Mon, 23 Mar 2015 12:02:34 GMT

Hello Andrew,

I have attached the sample application.

I have Sheet1, Sheet2, Sheet3, Sheet4.

Sheet1 and Sheet2 should have always one value selected for YEAR field, whereas Sheet 3 & Sheet 4 it should not be the case.

Thanks,

Vidhay

Re: Hiding field values in current selection box

awhitfield — Mon, 23 Mar 2015 12:12:27 GMT

http://www.learnqlickview.com/alternate-states-in-qlikview/

They are effectively duplicated object so selection on one sheet will affect all other sheets, you need to use alternate states to break the link between them, see the link above for usage examples..

Andy

Re: Hiding field values in current selection box

awhitfield — Mon, 23 Mar 2015 14:35:08 GMT

Example attached.

I've Created alternate state 'state1' and associated the list boxes on sheets 3 & 4 with this.

Andy

Re: Hiding field values in current selection box

Tue, 24 Mar 2015 04:40:13 GMT

Thanks a lot Andrew!

But i would like to reflect this in Current Selections box.

Year selection in 3 & 4 should not be seen in Curr Selection box.

Is there any way to hide it ?

See the attachment for more details

Thanks,
Vidhya

Re: Hiding field values in current selection box

awhitfield — Tue, 24 Mar 2015 09:29:53 GMT

Hi there,

you couldn't do it with the standard current selection object, but you can create your own.

Andy

See example

Re: Hiding field values in current selection box

Tue, 24 Mar 2015 10:01:22 GMT

Thanks a ton Andrew!

Re: Hiding field values in current selection box

awhitfield — Tue, 24 Mar 2015 10:18:15 GMT

No problem, if you are happy with my reply, please mark it as CORRECT, have a good day! Andy