topic Re: select possible values in filter in App Development

select possible values in filter

Anonymous — Tue, 13 Feb 2018 16:33:31 GMT

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

Re: select possible values in filter

JustinDallas — Tue, 13 Feb 2018 16:58:05 GMT

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.

Re: select possible values in filter

Anonymous — Tue, 13 Feb 2018 16:59:55 GMT

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

Re: select possible values in filter

Gysbert_Wassenaar — Tue, 13 Feb 2018 17:23:49 GMT

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.

Re: select possible values in filter

Anonymous — Tue, 13 Feb 2018 17:26:52 GMT

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)