Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

write max in dimension side

Hi all,

I want to write max function in dimension side without using sum.Administrator

13 Replies
MVP
MVP

If you mean calculated dimension, probably you have to use AGGR() function to use any aggregation function like your max().

Not applicable

Hi,

I want difference between Posting date and max(calender date) ,

so how to write it in dimension side.

MVP & Luminary
MVP & Luminary

Hi,

Try like this

=Rangemax([Posting date], [calender date]) - Will give you the max date in this two dates

= Date ([Posting date] - [calender date])  - Will give you the difference between the two dates

Can you attach some sample data.

Regards,

Jagan.

MVP
MVP

If you give us some more information, will be useful to give you right direction..

Not applicable

I need the no of days between the posting date and max CalenderDate.
 
  I have a calender in my report where I will select for eg. 7/31/2013
  and my database has the field Posting Date with different dates.
  So for each posting date I need the no of days with Calender Date.
  eg.
  1. Posting date is 6/25/2013.
  So no of days between 7/31/2013 and 6/25/2013 is 35 days.
 
  2. Posting date is 7/20/2013.
  So no of days between 7/31/2013 and 7/20/2013 is 10 days.
 
  So my calender will always be same until user changes the date selection in the calender.
      


  Please see the sample data.
  CalenderDate: 07/31/2013
     

Posting DateNo of Days
07/31/20131
07/30/20130
07/29/2013-1
07/28/2013-2
07/27/2013-3
07/26/2013-4
07/25/2013-5
07/24/2013-6
07/23/2013-7
07/22/2013-8
07/21/2013-9
07/20/2013-10
07/19/2013-11
07/18/2013-12
07/17/2013-13
07/16/2013-14
07/15/2013-15
07/14/2013-16
07/13/2013-17
07/12/2013-18
07/11/2013-19
07/10/2013-20
07/09/2013-21
07/08/2013-22
07/07/2013-23
07/06/2013-24
07/05/2013-25
07/04/2013-26
07/03/2013-27
07/02/2013-28
07/01/2013-29
06/30/2013-30
06/29/2013-31
06/28/2013-32
06/27/2013-33
06/26/2013-34
06/25/2013-35


  So I need to create this No of days column on dimensions side in Pivot table.

MVP
MVP

Is number of days is field or it is a result from some of your calculation?

Not applicable

it should be a calulated dimension

MVP & Luminary
MVP & Luminary

Hi,

Try Interval() like this

=Interval[Posting date] - [calender date], 'D')

Regards,

jagan.

MVP
MVP

No my question is NO OF DAYS need to be calculated based on POSTING DATE?

if yes, you can use like below..

Dimension = [Posting Date]

Expression

Max(CalendarDate)-[Posting Date]+1

or

Max(CalendarDate)-[Posting Date]