topic Re: Range in QlikView

Range

Tue, 25 Dec 2012 05:17:40 GMT

Dear all

user selected the from date to two date then should show the values

Re: Range

nirav_bhimani — Tue, 25 Dec 2012 05:46:37 GMT

Hi,

take two input box inside that create a variable.

vStartDate

vEndDate

try this Exp

=Sum({<Date={">=$(=vStartDate)<=$(=vEndDate)"}>}Sales)

Hope this will help you.

Regards,

Nirav Bhimani.

Re: Range

jagan — Tue, 25 Dec 2012 05:54:50 GMT

Hi,

=(sum({<SHKZG ={'S'}>} MENGE)) - (sum({<SHKZG ={'H'}>} MENGE))-----------openin

Regards,

Jagan.

Re: Range

Tue, 25 Dec 2012 09:03:10 GMT

thank for uer reply but it showing incorrect dates like 30-DEC-1988 ,please check it and send me once

Re: Range

jagan — Tue, 25 Dec 2012 10:26:08 GMT

Hi,

Check your date format and use this expression it works.

=Sum({<DateNum={">=$(=vStartDate)<=$(=vEndDate)"}>}Sales)

Regards,

Jagan.

Re: Range

jagan — Tue, 25 Dec 2012 10:32:58 GMT

Hi,

Try this,

=sum({<SHKZG ={'S'}, DateNum={'>=$(=Num(vStartDate))<=$(=Num(vEndDate))'} >} MENGE)

Regards,

Jagan

Re: Range

nirav_bhimani — Tue, 25 Dec 2012 11:26:13 GMT

Hi surik147

My expression is working.please find the attachment.

Regards,

Nirav Bhimani

Re: Range

jagan — Wed, 26 Dec 2012 10:56:10 GMT

Hi,

Please find attached file.

Regards,

Jagan.

Re: Range

jagan — Sun, 30 Dec 2012 04:44:51 GMT

Hi,

Regards,

Jagan.

Re: Range

Sun, 30 Dec 2012 11:32:39 GMT

hai

thank you for uer reply

=if((Datefield) < startdate ,(sum(if(ABC ='C,'XYZ))) - (sum(if(ABC ='D',XYZ))))

same expression i need in set analysis

Regards

surik147