Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
chriscools
Creator II
Creator II

no cumulative value in line chart when there are no actual values

Hello,

how do i need to make a linechart with a cumulative total that stops drawing a line when there are no actua values instead of keeping a straight line?

i can't seem to work this out...

This is expression i have:

sum({<[Fiscal Year]={'2023 - 2024'}, [KPI's]={'KPI 1:Retail / Tafelen'} >}[factuur tot net])/1000

 

Thanx a lot!

 

grtz,

Chris

Labels (1)
2 Replies
Dataintellinalytics

Please share sample data and snapshot.

chriscools
Creator II
Creator II
Author

Hello,

attached a simple example.

There is a monthly budget amount for the total year, but the actuals only go untill month 8.

So i would like to find a way to stop showing the cumulative bar chart if there are no values anymore for actuals.

Is that possible?

grtz,

chris