Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mogaka1234
New Contributor

Sum and age on latest transaction

Customer           Tdate          Value
A1-Nov-2015150
A1-Nov-2016200
A1-Nov-2017100
A1-Oct-201780
B24-Dec-201230011
B24-Dec-201522
B24-Dec-201428
C16-Sep-201334
C17-Sep-201312

How can i create a chart in Sense that has the sum(value), latest Tdate and Age(Latest Tdate - Now())?

Please assist.

1 Solution

Accepted Solutions
Quy_Nguyen
Contributor III

Re: Sum and age on latest transaction

Is this what you need

Capture.PNG

7 Replies
Partner
Partner

Re: Sum and age on latest transaction

Use below code in script n then try

Load Customer,

Max(Tdate) as Latest_Tdate,

Sum(Value) as Value,

Age(today(),max(Tdate)) as Age

From Source

Group by Customer;

mogaka1234
New Contributor

Re: Sum and age on latest transaction

I am not able to access the source thus i cant do it from load statement.

Partner
Partner

Re: Sum and age on latest transaction

what chart type you are planning to use ?

mogaka1234
New Contributor

Re: Sum and age on latest transaction

Just a table

antoniotiman
Honored Contributor III

Re: Sum and age on latest transaction

May be this

Quy_Nguyen
Contributor III

Re: Sum and age on latest transaction

Is this what you need

Capture.PNG

Highlighted
Partner
Partner

Re: Sum and age on latest transaction

could you please post a screenshot of your expected result?