Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

prasad
New 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..

Tags (3)
2 Replies
MVP
MVP

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

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
New Contributor III

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

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

Community Browser