Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

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
MVP
MVP

Re: how to show highest value

How about:

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

Highlighted
vikasmahajan
Honored Contributor III

Re: how to show highest value

use Firstsortedvalue function

Vikas

MVP
MVP

Re: how to show highest value

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
Contributor III

Re: how to show highest value

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 ? 

MVP
MVP

Re: how to show highest value

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
Contributor III

Re: how to show highest value

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

MVP
MVP

Re: how to show highest value

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).

MVP
MVP

Re: how to show highest value

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.