topic Re: how to show highest value in QlikView

how to show highest value

kunkumnaveen — Fri, 08 Apr 2016 09:53:50 GMT

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

Re: how to show highest value

jonathandienst — Fri, 08 Apr 2016 09:56:14 GMT

How about:

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

Re: how to show highest value

vikasmahajan — Fri, 08 Apr 2016 09:57:05 GMT

use Firstsortedvalue function

Vikas

Re: how to show highest value

sunny_talwar — Fri, 08 Apr 2016 09:57:46 GMT

May be something like this:

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

Re: how to show highest value

kunkumnaveen — Fri, 08 Apr 2016 10:02:43 GMT

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 ?

Re: how to show highest value

sunny_talwar — Fri, 08 Apr 2016 10:07:15 GMT

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

Re: how to show highest value

kunkumnaveen — Fri, 08 Apr 2016 10:13:12 GMT

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

Re: how to show highest value

swuehl — Fri, 08 Apr 2016 10:15:15 GMT

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

Re: how to show highest value

sunny_talwar — Fri, 08 Apr 2016 10:16:04 GMT

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.