topic Re: Table Chart - set to only display dates within the current year/month in App Development

Table Chart - set to only display dates within the current year/month

jerryr125 — Mon, 11 Nov 2019 08:49:31 GMT

Hi - I would like to have a setting on a chart that defaults to only displaying the current month/year of data.

Example - SalesDate is in the table - only show records in which the SalesDate is in the current month/year.

Thoughts ? Jerry

Re: Table Chart - set to only display dates within the current year/month

vunguyenq89 — Mon, 11 Nov 2019 08:55:52 GMT

You can apply Set Analysis to the measure expression of the chart. Check out this discussion https://community.qlik.com/t5/Qlik-Sense-App-Development/Set-analysis-current-month-and-year/td-p/1192940

Hope it helps!

BR,

Vu Nguyen

Re: Table Chart - set to only display dates within the current year/month

jerryr125 — Tue, 12 Nov 2019 18:28:06 GMT

Hi - I looked at the link below - I am trying to add the formula to a table to only display the current months data.

That does not seem to do the trick - thoughts ?

Re: Table Chart - set to only display dates within the current year/month

vunguyenq89 — Wed, 13 Nov 2019 07:31:13 GMT

Which expression have you tried? Can you also post some sample data?

Re: Table Chart - set to only display dates within the current year/month

jerryr125 — Wed, 13 Nov 2019 07:59:59 GMT

Hi -

Thank you again everyone for your help !

Ok - for example :

I have the table visualization (chart) on my sheet.

Display example :

SalesID ProductName SalesDate

123 Shirt 01/25/2019

456 Cap 11/06/2018

789 Hoodie 04/04/2019

534 Jacket 11/10/2019

I would like the table visualization (chart) to only display the following

SalesID ProductName SalesDate

534 Jacket 11/10/2019

Therefore - only sales in the current year/month.

Thoughts ?? Jerry

Re: Table Chart - set to only display dates within the current year/month

vunguyenq89 — Wed, 13 Nov 2019 08:24:43 GMT

You can create the expected table as follows:

Dimension = SalesID, ProductName
Measure = Only({<SalesDate = {">=$(=MonthStart(Today()))"}>} SalesDate)

BR,

Vu Nguyen

Re: Table Chart - set to only display dates within the current year/month

jerryr125 — Wed, 13 Nov 2019 14:35:19 GMT

Hi -

In the column (as a measure)

=Only({<([SalesDate]) = {">=$(=MonthStart(Today()))"}>} [SalesDate])

Does not work - thoughts ?

Re: Table Chart - set to only display dates within the current year/month

vunguyenq89 — Wed, 13 Nov 2019 14:49:13 GMT

Check if field [SalesDate] in your data is really a date field, otherwise convert it to date.

Below is the reload script I used to create the test data

LOAD SalesID,ProductName, Date(Date#(SalesDate,'MM/DD/YYYY')) as SalesDate Inline [ SalesID,ProductName,SalesDate 123,Shirt,01/25/2019 456,Cap,11/06/2018 789,Hoodie,04/04/2019 534,Jacket,11/10/2019 ];

With this data the above expression works

Re: Table Chart - set to only display dates within the current year/month

jerryr125 — Wed, 13 Nov 2019 17:19:09 GMT

HI - still not working - I created a column in my table (again - visualization chart) as a dimension - no luck - Jerryr

=Only({<SalesDate = {">=$(=MonthStartToday()))"}>} Sales.Date )