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: 
kunkumnaveen
Specialist
Specialist

how to show highest value

Hello All,

currently i am showing  recent score  and previous score of each parameter of each location, in a bar chart ,

but my client want me to show recent highest scores previous highest scores of each parameter irrespective of location fields..

what i mean is suppose if i select location = chanderia ,then i a bar chart i am showing all the latest scores and previous scores of each parameter for that particular location....

to achieve that i wrote each expression for each bar

expression for overall score current :

firstsortedvalue({<Category=,Decision=,name1=,ENSTEHDAT=,MaterialName= >} OVERALL_SCR, -ADATE) 

so on i wrote all the expression for each parameter

now my requiremnt is on of top each bar i have to show highest recent score irrespective of location selected

i mean in my slide 

for chanderia location: overall recent score is :71

so on top i need overall recent highest score among all location ....suppose highest score is 100 then i need 100 on top ..and this value should not change on any location selection.....

i think to achieve this i have to use a combo chart ,any how one value i am showing in bar so i think the highes values value i should show in dots

8 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

How about:

firstsortedvalue({<Category=,Decision=,name1=,ENSTEHDAT=,MaterialName= >} TOTAL OVERALL_SCR, -ADATE)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vikasmahajan

use Firstsortedvalue function

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
sunny_talwar

May be something like this:

Max({<Category=,Decision=,name1=,ENSTEHDAT=,MaterialName= , LOCATION =>}Aggr(FirstSortedValue({<Category=,Decision=,name1=,ENSTEHDAT=,MaterialName= , LOCATION =>} OVERALL_SCR, -ADATE), YourChartDimensions))

kunkumnaveen
Specialist
Specialist
Author

first thing is i have not used any dimension in this chart ,all the recent and previous score of each parameters i got them from expression so each bar has each expression,

so what my doubt is do i need to write again each of your expression for each parameter to get recent highest score  for each parameter

should i use combo chart ? 

sunny_talwar

Are you intending to do this in another chart or the same chart? I am not sure why you need a combo chart, but if you don't have any dimensions, you can try this (for all your parameters)

Max({<Category=, Decision=, name1=, ENSTEHDAT=, MaterialName=, LOCATION =>} Aggr(FirstSortedValue({<Category=, Decision=, name1=, ENSTEHDAT=, MaterialName=, LOCATION =>} OVERALL_SCR, -ADATE), LOCATION))

UPDATE: When I say for all your parameters, I mean you will have to add one expression for each of your parameter

kunkumnaveen
Specialist
Specialist
Author

No what i mean is currently i am using just bar chart  so it is possible to show two values on top of each bar

swuehl
MVP
MVP

I assume you have a cross table like data structure in your data model, each parameter in one field.

Maybe consider transforming this table to a straight table using a CROSSTABLE (Parameter, Value) LOAD prefix, then use the new Parameter field as dimension in your chart.

The Crosstable Load

This might simplify your charts to great extent, you probably only need one expression (and one for the max total value).

sunny_talwar

May be use text on axis option? I don't really know how this is going to play out since you don't have a dimension. But if you can share a sample of your application, we can play around with it.