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: 
steliosg
Partner - Contributor III
Partner - Contributor III

Set Analysis combine FirstSortedValue()

Hello,

I have the below expression:

sum({$<TransDate={"=firstsortedvalue({$<CashAmount={'>0'},DATE= {'<$(=OpeningDate)'} >} DATE,-DATE)"}>}Amount).

The firstsortedvalue returns one single date.Alone it works fine.But when i put it on the sum() i get the sum for all values(dates) of field TransDate  instead of

get sum for only single date equal to TransDate.

Any help will be appreciate!

10 Replies
tiklabaq
Creator
Creator

Hi Celambarasan and all other guys


a similar issue.

I want to show in the chart the sum of my amount at the last date of a month.

Example

MAT      Amount                Date

123           1                     28.01.2017

123           5                     28.01.2017

124           10                     31.01.2017

125           7                     31.01.2017

126           8                     31.01.2017

Result should be:

Month           Amount

01.2017           25