Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Partner - Creator III
Partner - Creator III

difference in Combo chart as line

Hi,

I need to get the difference between two dates as line in combo chart

i.e, if i select month feb-2018 combo chart should display feb 2018 data in day wise as bar and line should be difference of feb2018 - jan2018 as day wise.

But I am getting difference as zero when i try to subtract Feb-01,2018 & jan-01,2018.

Capture.JPG

How to get the difference as daywise in line without using inline script.

 

Sample attached

Thanks!!!

Labels (6)
1 Reply
ChiragPradhan
Creator II
Creator II

Hi,

Use this expression for your Difference measure -

if(RowNo(Total)=1, Sum(Amount), Sum(Amount) - Above(sum(Amount)))

If you do not wish to show a total for the first month, just use 

Sum(Amount) - Above(sum(Amount))

Regards

Chirag