Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ,
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
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
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
HI
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 ......