Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

max value display

Hello all,

sample data

Untitled.png

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

Untitled.png

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

1 Solution

Accepted Solutions

Re: max value display

Have a look at the attachment.

18 Replies
kunkumnaveen
Contributor III

Re: max value display

no..getting same o/p 0

Re: max value display

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

kunkumnaveen
Contributor III

Re: max value display

Hello,

sureshqv
Esteemed Contributor III

Re: max value display

u can create

in script

load *,

MONTH(Datefield) as month

day(datefield) as day

den u can use variable

Re: max value display

Have a look at the attachment.

Re: max value display

try this

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

kunkumnaveen
Contributor III

Re: max value display

Untitled.png

Untitled.png

kunkumnaveen
Contributor III

Re: max value display

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

maniram23
Contributor II

Re: max value display

Hi,

It is help full for you.

Community Browser