Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mandilicious
New Contributor III

Qliksense

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

6 Replies
rittermd
Honored Contributor

Re: Qliksense

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
Esteemed Contributor III

Re: Qliksense

am not sure

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

mandilicious
New Contributor III

Re: Qliksense

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
New Contributor III

Re: Qliksense

Hi Chanty

Tested its not working.

Thanks

rittermd
Honored Contributor

Re: Qliksense

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
Honored Contributor

Re: Qliksense

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.

Community Browser