topic Re: set Analysis in QlikView

set Analysis

Wed, 04 Feb 2015 11:32:07 GMT

Hi to All,

I have the data from 01 Dec 2008 to 03/02/2015... if we select any date between these dates,,i want get the data from 01/12/2008 to selected date.

My expression Like....

=sum({<postingdate={"<=$(=date(max(date)),'DD/MM/YYYY))"}>} quantity_in Base)

Above expression is not working pls help me.

I want display data from starting date to Selected date....

I did n't store any dates into variables..

i have my column Posting date,

Pls give me expresion for that...

Thanks for advance

please help me....

chandra

Re: set Analysis

Anonymous — Wed, 04 Feb 2015 11:35:14 GMT

Can you just attach sample application.

Re: set Analysis

PrashantSangle — Wed, 04 Feb 2015 11:35:47 GMT

Hi,

Check Date format.

and if possible share sample app.

Regards

Re: set Analysis

jonathandienst — Wed, 04 Feb 2015 11:38:21 GMT

You have a misplaced bracket and you need square brackets around the field with a space in the name:

=sum({<postingdate={"<=$(=date(max(date),'DD/MM/YYYY'))"}>} [quantity_in Base])

HTH

Jonathan

Re: set Analysis

Wed, 04 Feb 2015 11:49:49 GMT

Hi Jonathan,

thans for ur reply

its not working.

give me suggestion.

Re: set Analysis

Wed, 04 Feb 2015 11:51:45 GMT

Hi Max,

i entered both formatts like (1) DD/MM/YYYY

(2)MM/DD/YYYY

i checked both this formatts but its not working max.

Thanks for ur reply.

Re: set Analysis

Wed, 04 Feb 2015 11:55:22 GMT

Hi Chandra,

try this

=sum({<postingdate={">=$(=date(max(date)),'DD/MM/YYYY))"}, postingdate={"<=$(=date(max(date)),'DD/MM/YYYY))"}>} quantity_in Base)

This will work

Regards,

Lalit

Re: set Analysis

Wed, 04 Feb 2015 13:11:42 GMT

Hi to All,

Not getting Answer..

Thanks for ur reply.

Re: set Analysis

robert_mika — Wed, 04 Feb 2015 13:13:59 GMT

A sample of file would be helpful.

Re: set Analysis

jerrysvensson — Wed, 04 Feb 2015 13:19:14 GMT

Put this in a variable to verify that your formula works.

date(max(date),'DD/MM/YYYY'))

I don't know why you are complaing on not getting answers, most people on the forum is not paid by Qlik.

We help out when we have time.

Re: set Analysis

Anonymous — Wed, 04 Feb 2015 13:29:08 GMT

have you tried using single quotes ' your expression' in place of double quotes "

Re: set Analysis

Thu, 05 Feb 2015 04:34:00 GMT

Hi Jerry,

Dont miss understood,Not getting Answer in the sense"Pls help me out from this issue"That only my intention..

I might not be like that.. If u feel like that "SORRY".

Thanks.