Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
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

Labels (1)
4 Replies
jonathandienst

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

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