Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nazaninslp
Contributor III
Contributor III

how connect my calendar to mat charts and tables

Dears

I have DIME_DATE table in Sql

I have crated calendar with started and end date that gets from user.

I want to to connect this inputs to my charts and table

and when user enter the start and end date , it should be changed and extract report.

would you please help.

I have attached my Qlikview file.

 

Labels (3)
1 Solution

Accepted Solutions
kaushiknsolanki

Hi,

Add below link in your expression's Set analysis.

DATE_KEY = {">=$(=Date(vstartdate))<=$(=Date(venddate))"}

For example.

sum({<Area_Category-={"Test","Free ShortCode","Xtratime","ACS","Cloud"},DATE_KEY = {">=$(=Date(vstartdate))<=$(=Date(venddate))"}>}REVENUE)

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

4 Replies
kaushiknsolanki

Hi,

Add below link in your expression's Set analysis.

DATE_KEY = {">=$(=Date(vstartdate))<=$(=Date(venddate))"}

For example.

sum({<Area_Category-={"Test","Free ShortCode","Xtratime","ACS","Cloud"},DATE_KEY = {">=$(=Date(vstartdate))<=$(=Date(venddate))"}>}REVENUE)

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
nazaninslp
Contributor III
Contributor III
Author

Dear Kaushik
Thank youuuuuuuu
it is working fine, but when I press Clear Button , it doesn't apply to whole my sheet, and stay in date selection mode.
how can I fix it.
kaushiknsolanki

Can you share screenshot of that to understand it in detail.

Also if possible create a new post, because the topic of this post is different.

After creating post do tag me, or mail me the URL of that post.

 

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
nazaninslp
Contributor III
Contributor III
Author

Dear Kaushik
I've created new post
please help me
post detail:
How to Clear Date Values in Calendar Object and show the default value of started_date,End_date