topic Re: Line chart: hide future months in QlikView

Line chart: hide future months

simone_g — Mon, 08 May 2023 07:18:19 GMT

Hello,

I can't visualize data through a line chart correctly.

This is what I need to do:

Show all 12 months for each product
Hide the line for future months ( may 23, june 2023, etc.)
If in the past there were no sales for a specific month, set the line to zero

Please see the attachment.

Thank you in advance!

Re: Line chart: hide future months

MayilVahanan — Mon, 08 May 2023 07:46:25 GMT

Instead of 2 measure, Try like below

Dim: Month, Year
Exp: Sum(Sales )+ sum( {1} 0 )

It will help you

Re: Line chart: hide future months

simone_g — Mon, 08 May 2023 10:42:36 GMT

Thank you! It was helpful! 🙂

Now suppose that I have sales data from 2021 to 2013. Is it possibile to show just the last two years in the line chart (i.e. 2022 and 2023)?

Can I hide sales data of the current month ? For example, sales data of 2023-05-01 ? I would like to hide them because the full data for the current month are not available yet.

Please see the attachment.

Thank you !

Re: Line chart: hide future months

MayilVahanan — Tue, 09 May 2023 02:20:11 GMT

Try like below

Sum( {<year={">=$(=year(today())-1)"}, Date={"<$(=MonthStart(Today()))"}>} Sales ) + sum( {1<year={">=$(=year(today())-1)"}, Date={"<$(=MonthStart(Today()))"}>} 0 )