topic Last 6 months - Line Chart in QlikView

Last 6 months - Line Chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Per other blogs I have the below expression. I would like to only display the lattest 6 months.

Current Expression that I'm using below but nothing has changed. Could it be that MC_SERVICE_DATE_YYYMM is not in a date format?

SUM({<MC_SERVICE_DATE_YYYYMM={'>$(=AddMonths(Max(MC_SERVICE_DATE_YYYYMM),-6))'}>} TOTAL_PHONE_CONTACTS)

sinanozdemir — Tue, 05 Jul 2016 13:45:03 GMT

Hi,

Could be. Try to put Max() function in a Date(Max(MC_SERVICE_DATE_YYYYMM), 'Your Date Format')

Anonymous — Tue, 05 Jul 2016 13:49:53 GMT

Can you provide an example of how the full expresion should look?

Anonymous — Tue, 05 Jul 2016 13:52:23 GMT

The sums are correct but my current expression is not displaying only 6 months/values

sinanozdemir — Tue, 05 Jul 2016 13:53:06 GMT

Since I don't know your date format, but you can use 'MM/DD/YYYY' or 'YYYY-MM-DD' in 'Your_Date_Format' field. This should work:

SUM({<MC_SERVICE_DATE_YYYYMM={'>$(=AddMonths(Date(Max(MC_SERVICE_DATE_YYYYMM),'Your_Date_Format'),-6))'}>}TOTAL_PHONE_CONTACTS)

Anonymous — Tue, 05 Jul 2016 14:04:28 GMT

My dimesion is not a date. I was able to only display x values by using the Dimesion Limits tab to show FIRST x values, worked great.

jonas_rezende — Tue, 05 Jul 2016 14:23:38 GMT

Try:

SUM({<MC_SERVICE_DATE_YYYYMM={">$(=AddMonths(Max(MC_SERVICE_DATE_YYYYMM),-6))"}>} TOTAL_PHONE_CONTACTS)

SUM({<MC_SERVICE_DATE_YYYYMM={">$(=Date(AddMonths(Max(MC_SERVICE_DATE_YYYYMM),-6)))"}>} TOTAL_PHONE_CONTACTS)

Anyway, replace simple quote for double-quote.

Hope this helps!