Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ishansjain2095
Creator
Creator

How to add variable in Table chart Dashboard?

Hi All,

Using variable name as 'vTodayDate' i.e.

"=Date(Today(),'YYYY-MM-DD')"

 

How to map this in table chart for count() function???

 

Regards,

Ishan

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

>>How to map this in table chart for count() function???

Its not clear what your mean. Please expand on this request, preferably with an example. To append the variable to a caption or header:

.... & vTodayDate

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
ishansjain2095
Creator
Creator
Author

Hi Jontydkpi,

I am trying to add date as 'YYYY-MM-DD' in count() function to map tables like to sum of employees I need to find out.

Sharing you a sample example pic as attachment. Please solve the query asap.

 

Regards,

Ishan

jonathandienst
Partner - Champion III
Partner - Champion III

Count({<... , CommonDate = {'$(vTodayDate)'} ...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
ishansjain2095
Creator
Creator
Author

Hi,

Thanks for the query but it isn't working. Can you help me how can I user variable to get today's date for the respective tablename.

 

Regards,

Ishan