Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thank you for your reply Justin. My requirement is only to show the possible values of the input.
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.
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)