Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Maximum of Multiple values over one dimension

Hi All,

In my data source i have a table like below,

Invoice #Actual On Board Date
1665223/07/2018
1665223/07/2018
1665223/07/2018
1665223/07/2018
1665223/07/2018
1665223/07/2018
1665324/07/2018
1665425/07/2018

What my objective is to create a table like this,

Invoice #                No Of Days
1665232
1665331
16654

30

Here No Of Days  is calculated by the formula

No Of Days = Today()-Actual On Board Date

i am getting NULL for the invoice number 16652 in Qlikview chart which i want to create. Other invoice numbers gets correct values. i think this is because the invoice number 16652 has multiple dates. any how Highly appreciate if some one could help me sorting this out.

Thank you

1 Solution

Accepted Solutions
Specialist II
Specialist II

It looks like you have a timestamp field but displaying in the date format. Can you try loading the field as Date(floor(Actual On Board Date), 'YourDateFormat').


and as Gabriela suggested, you can use max with the aggregation as well, like -

Today()- Aggr(max(Actual On Board Date), [Invoice #])

View solution in original post

5 Replies
Partner
Partner

try this as the expression:

Today()-max(Actual On Board Date)

Contributor III
Contributor III

Hi Gabriela

Thank you for your response.. I have tried this before..but didn't work.. this gives null for the first row of the 2ND table..

Partner
Partner

Can you send an example QVW?

Specialist II
Specialist II

It looks like you have a timestamp field but displaying in the date format. Can you try loading the field as Date(floor(Actual On Board Date), 'YourDateFormat').


and as Gabriela suggested, you can use max with the aggregation as well, like -

Today()- Aggr(max(Actual On Board Date), [Invoice #])

View solution in original post

Contributor III
Contributor III

Thank a lot for both of your support. Neelam, It worked with Aggr funtion.

thanks once again.