Select a date, show 2 weeks prior that date including it.

[Anonymous]

Hello everyone!

I have 2 sheets with a master calendar (Date,Month and year). One sheet has 6 graphs with all KPIs and the other sheet has a table view with the same KPIS. I would like to click on the tabular view a specific date and show that date and 2 weeks prior on the graph sheet. Is it possible?

Thanks!

[jyothish8807]

Hi Karim,

 May be try like this in your bar chart:

for example "Date" is the field your using in "DD/MM/YYYY" format:

Create a variable:

vDate: Getfieldselections(Date)

Then in bar chart try like this:

sum({<Date={"> $(= date(num(Weekstart(max($(vDate))))-14,'DD/MM/YYYY')< date(Weekstart(max($(vDate))),'DD/MM/YYYY'))"}>}Sales)

[Anonymous]

Hi,

Thanks for your help but it does not seem to  work. Have you opened the mock data file I uploaded ?

Regards,
Karim

[jyothish8807]

Sorry, i do not have QS installed on my system right now, so just made a draft from my understanding. 🙂

[Anonymous]

No problem. Thank you.