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: 
Anonymous
Not applicable

Set Analysis and Variables (Date)

Hello,

I am trying to compatre a date in my aplication with a variable. The requirement is to have a user select a date and then compare it to the variable. I cannot get the syntax to compare the variable to my calendar.

The part in Bold is giving my syntax errors and I cannot get it to work - in spite of trying lots of combinations.

Any advise would be appreciated!


sum(
{<Calendrier.Date = {*},Calendrier.Annee = {*},Calendrier.Mois = {*}, SALES.Salesman_-={"Intercompany"},
Renew1.Renew.Renewal_Date = $(>= vLower_Date )
>} Renew1.Renew.Net_Price )

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum({<Calendrier.Date = {"*"},
      Renew1.Renew.Renewal_Date = {">=$(vLower_Date)"}>}
Renew1.Renew.Net_Price)

View solution in original post

8 Replies
sunny_talwar

Syntax isn't right.. may be try this

Sum({<Calendrier.Date = {*},
Calendrier.Annee = {*},
Calendrier.Mois = {*},
SALES.Salesman_ -= {"Intercompany"},
Renew1.Renew.Renewal_Date = {">=$(vLower_Date)"}>}
Renew1.Renew.Net_Price)
Anonymous
Not applicable
Author

Hi - thanks for your help - i'm aware that it's a syntax issue - i'm still having errors with your syntax though
sunny_talwar

What is the error message that you get?

Anonymous
Not applicable
Author

Errors in expression -so a syntax error 

sunny_talwar

Would you be able to share a screenshot of your syntax editor? I mean is it possible that you have incorrectly typed one of your field names, like is the field name 

SALES.Salesman_

or

SALES.Salesman

 

Anonymous
Not applicable
Author

Hi i've reduced it down as much as possible. I'll try to make a simple app if you think that's better

sunny_talwar

Try this

Sum({<Calendrier.Date = {"*"},
      Renew1.Renew.Renewal_Date = {">=$(vLower_Date)"}>}
Renew1.Renew.Net_Price)
Anonymous
Not applicable
Author

Thank you so much 🙂