Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nazaninegogo
New 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

Re: how connect my calendar to mat charts and tables

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

4 Replies

Re: how connect my calendar to mat charts and tables

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

Highlighted
nazaninegogo
New Contributor III

Re: how connect my calendar to mat charts and tables

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.

Re: how connect my calendar to mat charts and tables

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

nazaninegogo
New Contributor III

Re: how connect my calendar to mat charts and tables

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