Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

i want to check a date in date list

Hi friends

I want to check a user given date in date list .whether is it there or not, If there means I need to show sum of values automatically.

I did it but it show me when I select date from date list  which is same as i was entered in input box. But I need to show the value without selecting date from list box..

Vdate.PNG

This is the variable using in an input box. and my expression is

=if((Date=vDate),Sum(Value)) when i select '08-06-2015'  from date list it show me sum of value of the date. But I want to show the sum of value without am selecting value from date list....

And my table is

table.PNG

I am waiting for your response friends.,....

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Exp: Sum({<Date={'$(vDate)'}>} Value)

Right click on input box->Properties->Number ->Mixed

Enter the date in DD MMM YYYY format in input box

Untitled.png

View solution in original post

12 Replies
tresesco
MVP
MVP

Try like:

Sum({<Date={'$(vDate)'}>} Value)

Remember the entered date format and date in field format have to be same. I.e, enter date value like vDate = 08 Jun 2015

MarcoWedel

check your date formats.

your screenshots show different ones.

regards

Marco

Not applicable
Author

Hey Thank for your response. but it not works perfectly. I just paste that exp In a text box it show me 0. Even I select a date from date list also.

MK_QSL
MVP
MVP

SUM({<Date = {"$(=Date(Date#(vDate,'DD-MM-YYYY'),'DD MMM YYYY'))"}>}Value)

Not applicable
Author

Yeah It look diff from my input but it accept my date which enter in input box. and show the sum of value when I select the same date from date list. at the same time it doesn't show any value if I didn't select any date from date list or select a wrong date....

tresesco
MVP
MVP

Try to post a sample qvw.

Not applicable
Author

Friend show me whether user input date is available  in a list or not by using a text box. It should be done without selecting the same date from date list

tresesco
MVP
MVP

PFA

Not applicable
Author

hey I can't open this file because am using personal edition only. Can you please send screenshot of the desired output or please paste the expression as a reply...