Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How load only a particular day of week

Dear all,

I have a question:

1. I have a table that contains my daily balances. I need to create a chart giving the balance for each friday of week.

My idea is to load from database only those records where the date is a friday.

Is there any way to do this chart without to have a different select and have in the same app the possibility to view the balance and a chart that shows only the records where the date is a friday?

Thank you

13 Replies
Not applicable
Author

Dears, many thanks to all.

The only my doubt is that my weekday return is in italian so instead to specify in my expression the text 'Fri" I've specified "Ven' i.e. in italian. I'm not sure if someone that has the language in english could have a wrong result.

I would like attach my final file so that it could be usueful for others but I can't find the attach file button in this comments. How i can do it?

thank you

rustyfishbones
Master II
Master II

Can you mark the correct answer

rustyfishbones
Master II
Master II

Use the advanced editor on reply

2015-02-20_1524.png

And then select Attach

2015-02-20_1525.png

Not applicable
Author

Dear all. Please find attache my file.

Thak you