Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
marjan_it
Creator III
Creator III

how to get max in a calculated Dimension in chart

Hi All,

I have a straight table that my dimension is like this:

=if(im_projectID=8231 or im_projectID=8194 or im_projectID=4302 or im_projectID=8230 or im_projectID=10117 or im_projectID=694 or im_projectID=10677 or im_projectID=10536 or im_projectID=10512 or im_projectID=5594 or im_projectID=11518 ,im_projectID)

and for expression I have sum (im_ProjectBudget). I want to get the max of (im_ProjectBudget) for just these im_projectID, not for all of them.

how can do it?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

You can replace your calculated dimension with a simpler one like:

=If(Match(im_projectID, 8231,8194,4302,8230,10117,694,10677,10536,10512,5594,11518), im_projectID)

 

And then the expression like:

Max( TOTAL {<im_projectID={8231,8194,4302,8230,10117,694,10677,10536,10512,5594,11518}>} im_projectID)

 

View solution in original post

1 Reply
tresesco
MVP
MVP

You can replace your calculated dimension with a simpler one like:

=If(Match(im_projectID, 8231,8194,4302,8230,10117,694,10677,10536,10512,5594,11518), im_projectID)

 

And then the expression like:

Max( TOTAL {<im_projectID={8231,8194,4302,8230,10117,694,10677,10536,10512,5594,11518}>} im_projectID)

 

View solution in original post