Apply filters to the data only after the server updates

[JonesBeach]

Greetings all,

Thanks to whoever comes forth for help! 

I am fairly new to qliksense and having hard time understanding it. I have experience with Power Bi but my company does not uses that as an authorized platform for dashboard development. 

I have a data set and I want it to be filtered for certain products only for each SKU number. Is there a way to have those product filters applied only when the server updates the data at 2:00am each day and when that happen could those be rows be highlighted that fulfills the filter requirements. Thanks again for help!

Basically after the update which ever SKU number has a Product GNT933, GNT222 or GNT456 associated to should get highlighted. 

I am attaching a pseudo data file for you to work with 🙂 

[JonesBeach]

Hi Ruben, This works just fine. However, (And I hate to bother again) when I run this it shows data like this 

SKU#	Date	Products	flagAdded	DateAdded	flagRemoved	Date Removed
SKU-21	1/10/2021	GNT456	1	1/10/2021	0
SKU-21	1/10/2021	GNT545	0		1	1/10/2021
SKU-21	1/10/2021	GNT933	1	1/10/2021	0

But we wanted to see for all the products collectively or even if it is showing it like that then dont show it as flagAdded bc its doing all of that on the same date but adding and removing flags based on the individual products where as we wanted to see flagAdded if it adds on a different date later on. So in other words if it changes later on but not on the same date. This means its flagging for the same date for each product separately. So when it saw GNT 933 is associated, it showed 1 in flagAdded column, then it saw GNT545 is not associated and it said 0 and also in flagRemoved column it said 1 and showed the date for the same day and then it saw GNT456 is associated and showed flagAdded and showed the date in DateAdded. 

Thank You Sir for all the help so far. I didnt have much hope with this but you got me this far.

[rubenmarin · Accepted solution]

Hi, but the initial data has all products in one row, not in different rows.

It will be better post a sample data to check what it does, and the values you expect to be returned.

[JonesBeach]

Its actually correct the fields being pulled from the data base had something wrong in it. Thanks so much Ruben!