Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Cummulative expression and Line chart

Hi ,

How to build the following chart :

Input
Trading Day12345
Sales500100020005001000
Budget002000000
Budget=20000/5 is 4000
Output
Trading Day12345
Sales5001500350040005000
Budget40008000120001600020000

Please find the attachement sample

In the sample model . I am using vPerFormula and vPerFormulaBud to calculate the sales and budget resp.

For the Sales Value and Budget Value calculation I need to use the variables vPerFormula and vPerFormulaBud.

By using the variables I need to build a chart . by Trading Day and the cummulative sum

My requirement is :

The output needs to be reflected in the chart.

pfa.

0 Replies