Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an ordinary QlikSense table of data, which includes Date as one of its fields. The data that I'm showing is only valid on Sundays, but when you click the search box at the top of the table, you get every date in the dataset (which, because it's joined to a lot of other things, includes a LOT of dates that don't have data).
Is it possible to get this search filter on the table to show only the dates that actually appear in the set?
Hi @mhaandreas1
Would it work if you use Weekday() in a If statement?
If the date has weekday equals 6 and 7 i means it is a weekend and should be displayed other wise not.
With that code in your list box it should work as you expect.