Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Range

Dear all

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Range

Hi,

Regards,

Jagan.

9 Replies
nirav_bhimani
Contributor III

Re: Range

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.

MVP
MVP

Re: Range

Hi,

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

Regards,

Jagan.

Not applicable

Re: Range

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

MVP
MVP

Re: Range

Hi,

Check your date format and use this expression it works.

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

Regards,

Jagan.



MVP
MVP

Re: Range

Hi,

Try this,

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

Regards,

Jagan

nirav_bhimani
Contributor III

Re: Range

Hi surik147

My expression is working.please find the attachment.

Regards,

Nirav Bhimani

MVP
MVP

Re: Range

Hi,

Please find attached file.

Regards,

Jagan.

MVP
MVP

Re: Range

Hi,

Regards,

Jagan.

Not applicable

Re: Range

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

Community Browser