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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
LP27
Creator II
Creator II

Difference between two rows in Qlik sense

Hi Everyone,

I need to figure out the best logic to calculate the difference between two rows.

for example :-

Week123
Count of Yes100200250
Count of No2050100
Week123
Drop off Yes 100500
Drop off No3050

0

 

The values for Count of Yes and Count of No are appeared based on filter selections.

I just need to figure out the logic for calculating  Drop off Yes and Drop off No.

Logic for Drop Off Yes = Count of Yes(2) - Count of Yes(1)  ie. 200-100=100

Logic for Drop Off No = count of No(2) - Count of No(2) ie. 50-20=30

 

 

Let me know if you have question.

Labels (2)
3 Replies
sunny_talwar

Would you be able to share a sample to where we can see what you have?

LP27
Creator II
Creator II
Author

Sorry Sunny! 

At this moment i have got only this scenario.

I am looking to build something with same scenario mentioned, so wanted to get ideas on that. 

 

LP27
Creator II
Creator II
Author

is it possible to be done ?