
Creator
2022-04-04
02:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Cumulative trend (raising trend) % in Qliksense
Hi all,
I am trying to calculate Cumulative % and show it in a line chart. Below are the issues I am facing:
1. My x axis is allocation month which looks like 0,1,2,3,4
2. my lines are values of a category like A1, A2, A3
3. I have num variables bal and amt
4. Bal is denominator for my % calculation which is sum of BAL by Quarter/3 - and this result will be constant across POINT1 - it will e same for 0,1, 2,.... 32
5. AMT is Numerator which is Sum of AMT by Quarter/3 for each values in POINT1 - 0,1 2,3.
6.
Kindly help in achieving the table 2 formula in QlikSense
Labels (6)
Labels
- Subscribe by Topic:
-
Developers
-
dimension
-
expression
-
General Question
-
Set Analysis
-
Visualization
367 Views
1 Reply

Creator
2022-04-04
02:43 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Attached the file with dummy data
363 Views
