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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Set Analysis without the sum statement in a line graph.

Hi All,

I want to fix two indicators for my reports and want to see their values on a monthly basis for the last 10 years. I tried using the SET statement but its giving me an accumulation of the figures. How do i avoid this accumulation?

For eg - The index value for one indicator is 80, 82, 84, 102 ....so on. When i am using the SET analysis sum statement....the x axis value is showing an accumulation of the total monthly values. Instead of starting from 80, my graph is starting from 500.

Can anyone help?

Regards

Ani

0 Replies