Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
prasad
Contributor III
Contributor III

how to get the difference in rows group by each person and date.

NameofpersonDateofweightWeightDifference
aa13/01/201355
aa14/01/20136510
aa16/01/201355-10
aa20/01/20137318
bbb13/01/201342
bbb14/01/201340-2
bbb16/01/201335-5
bbb20/01/2013405
bbb25/01/201337-3
bbb30/01/201333-4

In the above example, I am trying to get the difference between 2 dates (only negatvie nos only) for each person on different dates. Is there any function for this. Please guide onthis. Thanks in advance..

2 Replies
maxgro
MVP
MVP

if I understand your question try with a chart (straight table)

dimension

- name

- dateofweight

expression

- weight

- if(sum(Weight) -  Above(sum(Weight)) <0, sum(Weight) -  Above(sum(Weight)))

disable user sort

see attachment

prasad
Contributor III
Contributor III
Author

ThankU very, much..I will try and update this ..