topic Re: max value display in QlikView

max value display

kunkumnaveen — Wed, 13 Jul 2016 05:39:22 GMT

Hello all,

sample data

when i select max date i was suppose to get 500 as value but i am getting 0

Varibles:

vMindate = 3sep;

vMaxdate = Date;

expression:=sum({<Date={"$(vMindate)"}>}value) = 100

sum({<Date={"$(vMaxdate)"}>}value) =500 (Not Working)

wats going wrong in my above statement?

thanks

Re: max value display

kunkumnaveen — Wed, 13 Jul 2016 05:45:55 GMT

no..getting same o/p 0

Re: max value display

settu_periasamy — Wed, 13 Jul 2016 05:50:48 GMT

Is that date format? Can you share the sample qvw?

Re: max value display

kunkumnaveen — Wed, 13 Jul 2016 05:53:22 GMT

Hello,

Re: max value display

Chanty4u — Wed, 13 Jul 2016 05:55:58 GMT

u can create

in script

load *,

MONTH(Datefield) as month

day(datefield) as day

den u can use variable

Re: max value display

tamilarasu — Wed, 13 Jul 2016 05:57:52 GMT

Have a look at the attachment.

Re: max value display

settu_periasamy — Wed, 13 Jul 2016 05:59:35 GMT

try this

=sum({<Date={"$(=$(vMaxdate))"}>}value)

Re: max value display

kunkumnaveen — Wed, 13 Jul 2016 06:03:30 GMT

Re: max value display

kunkumnaveen — Wed, 13 Jul 2016 06:04:25 GMT

=sum({<Date={"$(vMindate)"}>}value)

Re: max value display

maniram23 — Wed, 13 Jul 2016 06:04:32 GMT

Hi,

It is help full for you.

Re: max value display

tamilarasu — Wed, 13 Jul 2016 06:05:57 GMT

I have attached a sample in my previous reply.

Re: max value display

settu_periasamy — Wed, 13 Jul 2016 06:07:49 GMT

Hi Naveen,

you need to change the variable vMaxdate as =Date

or you can use the expression like

=sum({<Date={"$(=$(vMaxdate))"}>}value)

note: It seems, your Date field is not properly formatted. Max(Date) won't work for you, it will give the max string.

Re: max value display

kunkumnaveen — Wed, 13 Jul 2016 06:22:23 GMT

thanks for ur help..its working

i am trying to display SUM b/w min value and max value(selected from calendar box)

let say if i select 5sep from Calendar box

sum has to be from (100+200+300)

if i select 6sep =(100+200+300+500)

something is missing from my expression :

=sum({<Date={">=$(vMindate)<=$(vMaxdate)"}>} value)

Re: max value display

kunkumnaveen — Wed, 13 Jul 2016 06:25:13 GMT

Hello settu,

i am trying to display SUM b/w min value and max value(selected from calendar box)

let say if i select 5sep from Calendar box

sum has to be from (100+200+300)

if i select 6sep =(100+200+300+500)

something is missing from my expression :

=sum({<Date={">=$(vMindate)<=$(vMaxdate)"}>} value)

Re: max value display

tamilarasu — Wed, 13 Jul 2016 06:37:44 GMT

Naveen,

Have a look at the attachment.

Re: max value display

kunkumnaveen — Wed, 13 Jul 2016 07:00:15 GMT

yes both requirement look similar but only the problem is over here i want to add extra one thing i mean

Group1(comparative analysis)

Varible:

vMindate=3sep (remain same)

vMaxdate=only({group1}date).....(need help over here)

expression :

=sum({group1<Date={">=$(vMindate)<=$(vMaxdate)"}>}value)

Re: max value display

kunkumnaveen — Wed, 13 Jul 2016 07:00:51 GMT

yes both requirement look similar but only the problem is over here i want to add extra one thing i mean

Group1(comparative analysis)

Varible:

vMindate=3sep (remain same)

vMaxdate=only({group1}date).....(need help over here)

expression :

=sum({group1<Date={">=$(vMindate)<=$(vMaxdate)"}>}value)

Re: max value display

kunkumnaveen — Wed, 13 Jul 2016 07:29:57 GMT

Hi,

sorry for annoying you man ..can i ask you one thing ,is it necessary to do this at script level

Load Date(Date#(Date,'DMMM'),'DMMM') as Date, value;

because i tried by commenting this ,then it was not working.....

vMaxdate =Date(Max({group1}Date),'DMMM')

is there any other way instead of writing this at script level (as i got 12tabs and i have no clue from which tab the date is popping up)

Re: max value display

tamilarasu — Wed, 13 Jul 2016 07:47:26 GMT

No Problem Naveen. You need to interpret the date field in script level else the field will be considered as text field. So you can not perform calculation between the dates (on the text field).