Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
bsrravikumar
Not applicable

select possible values in filter

hi,

How to make qliksense automatically select possible value.

Ex:

in filter there are below values.

12-56

23-67

45-88

67-44

56-60

for general filter search if we give 56 as input we get only 56-60 in the list.

what needs to be done if we want to see 12-56 also in that list.

so i need to give *56* to get both 56-60 & 12-56.

but my data is in thousand how to handle such case.

please let me know of any clues

4 Replies
JustinDallas
Not applicable

Re: select possible values in filter

Hello Raghav,

Have you tried bucketing?  This would allow you to have multiple overlapping buckets and a datapoint could belong to more than one of them.

Orders:

Load * Inline

[

    orderId, orderDurationMinutes

    1, 25

    2, 46

    3, 78.9

]

;

DurationBuckets:

LOAD orderId , '12-56' AS 'DurationBucket' Resident Orders

     WHERE orderDurationMinutes >=12 AND orderDurationMinutes <= 56

;

LOAD orderId , '23-67' AS 'DurationBucket' Resident Orders

     WHERE orderDurationMinutes >=23AND orderDurationMinutes <= 67

;

Of course there are ways to be more clever and more robust with your buckets, but it's a start.

bsrravikumar
Not applicable

Re: select possible values in filter

Thank you for your reply Justin. My requirement is only to show the possible values of the input.

Gysbert_Wassenaar
Not applicable

Re: select possible values in filter

Add a filter pane object and add the field with the interval values as dimension for the filter pane.

Click on the Magnifying Glass icon to open the search input field. Enter *56* in the input field and press enter.

c291258.png


talk is cheap, supply exceeds demand
bsrravikumar
Not applicable

Re: select possible values in filter

yes, this what i needed, but my input should not be like *56*, i simply enter 56 even then i need to get 56-60 & 12-56. in my list,


i tried with this expression, still no luck

=aggr(only({1<Part_Number= p(Part_Number)>}Part_Number),Part_Number)