Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
karimtalan
Contributor
Contributor

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

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!

4 Replies
jyothish8807
Master II
Master II

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)

 

Best Regards,
KC
karimtalan
Contributor
Contributor
Author

Hi,

 

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

Regards,
Karim

jyothish8807
Master II
Master II

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

 

Best Regards,
KC
karimtalan
Contributor
Contributor
Author

No problem. Thank you.