Qliksense

[mandilicious]

Hi All

Please help i have apps that run 3 times a day (07:30,12:30,16:30)when i click Time i need to see only 3 times hides others that are Greyed out ?

Thanks

[rittermd]

This is the way that Qlik Sense works. 

White means that you have active data and can pick one of these choices.

Grey means that the data is not available but is in the data that was loaded.

It may be possible to limit to just the 3 by coding an expression in your Time filter instead of just displaying the Time field.  But I don't know your data.

[Chanty4u]

am not sure

=aggr(only({<Date= P(Date)>}Date),Date)

[mandilicious]

Hi Mark

Thanks for the respond i tried explained to them that it shows active data,just that client need to see only 3 times per day.

[mandilicious]

Hi Chanty

Tested its not working.

Thanks

[rittermd]

Are those always the time values?  Are you displaying a field that just has the time in it or are you getting it from a date/time field?

[rittermd]

If those are the only values you could create an inline table with those values and link that table to your data by using the same name for both fields.

Then use the inline table as your filter.  It will then only display the 3 values you have in that table.