topic Current Selection Box Problem in QlikView

Current Selection Box Problem

sasikanth — Thu, 31 Jul 2014 06:48:33 GMT

HI Guys

I have a problem with curent selection box,

i have created a Bucket in the front End using 3 diffrent Fields which is not possible at script level

Ex: Age bucket

30 and below

31 to 40

41 to 50

5 and above

when i am selecting a value from that bucket ,

current selection box is displaying all the fields that i have used for making that bucket

can any body help me on this issue how can i show the same values in current selection box as in bucket

let me know if there is any indirect way

Thanks ,

Re: Current Selection Box Problem

datanibbler — Thu, 31 Jul 2014 06:54:00 GMT

Hi sasikanth_Narne,

the statusbox (or current_selection_box) is a standard object in QlikView and by default displays all the fields on which you have made a selection.

There is no way around that.

A possibility would be to use the system_variable > HidePrefix < to permanently make a field invisible - then it won't show up in statusboxes - but then it never will, that is static, set in the script. I think that is not what you want, is it?

Please try to explain a bit more precisely, or post a sample of how you have made those buckets - are there really selections in all these fields involved - and are they necessary? - maybe there is another way of doing it involving fewer fields, that would be the more elegant method.

HTH

Best regards,

DataNibbler

Re: Current Selection Box Problem

SunilChauhan — Thu, 31 Jul 2014 06:54:52 GMT

Current selection working @ field Created in script

not @ expression created @ front end

so if you select creted age bucket @ front end

it will select Original field on which bucket is based on.

and if you would create it in script and make a field age_bucket. it will show selection according to this field

I think its not possible @ front end level

hope this helps

Re: Current Selection Box Problem

sasikanth — Thu, 31 Jul 2014 13:17:52 GMT

hi DataNibbler

i have searched for all possible scenarios but , i did`nt

i will explain a bit better

i have made age bucket on two fileds

one is CREATED_DATE and CAL_YEAR

if( $(=max(CAL_YEAR))))-year(CREATED_DATE)>0 and $(=max(CAL_YEAR))))-year(CREATED_DATE)<=30),'30 and below' ,...

.......

like above

and the bucket should be like below

30 and below

31 to 40

41 to 50

5 and above

if i click on any one then it is givig both the values CREATED_DATE and CAL_YEAR in current selection box

is there any way so that i can show only the bucket categories like

if i select 31 to 40 then it should show that only

Thanks

Re: Current Selection Box Problem

sasikanth — Thu, 31 Jul 2014 13:19:03 GMT

chauhan

i know that if we make that at back end then you will get only a single field

but these fields are comming fro 3 diff tables ,

so can we have any way to achieve that one ......