Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

Show data for current week

Hi!

I have an app where i want to  show the number of Tickets for the current week no matter what other date filters that are used in the app.

E.g. the date filter could be set for the previous 3 months and the result is presented in a graph but I also want to present the value for the current week

 

35 Replies
bramkn
Partner - Specialist
Partner - Specialist

Easy thing to do is to place the weekstart and weekend in a variable. and then you can do {">=$(vThisweekstart) <=$(vThisweekend)"} for example. don't forget to include all calendar fields in the set analysis.
stekol61
Creator
Creator
Author

The thing is that the app is only using Week or Month (even though W & M are created from date).
So the result should be presented as one value for the current week
Shubham_Deshmukh
Specialist
Specialist

Have you gone through my reply and screenshots?
stekol61
Creator
Creator
Author

I did and they looks OK.
However, my app will only use and present data for Week or Month, not for Date.

One progress is that I created a separate LOAD for Ticket_Id, Date and Country and now I can avoid the "main" filers. Problem now is that the Count (Ticked Id_new) shows the result for the entire time period and not for the current week
Shubham_Deshmukh
Specialist
Specialist

can you share your sample data and sample app?
Bcoz m not getting not as it is very simple one, I loaded the same things and applied the exp, I got results.
stekol61
Creator
Creator
Author

Hi!

Enclosed is my app with some sample data.

So, what I want to see is number of tickets (wor_ticket_ID) per country for the current week and also for the current month