Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Set analysis issue

Hi ,

We have used the set analysis and it gives right results.

But the syntax is showing error script as below.

Is there any way to get the same logic in different syntax.

Logic:

sum({$<[Calendar Date]={'>=$(=Date(Monthstart(max([Calendar Date])), 'DD-MMM-YYYY')) <=$(=Date(MonthEnd(max([Calendar Date])), 'DD-MMM-YYYY'))'}>}[# QN Initiated])

Capture.PNG

Thanks..

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

sum({$<[Calendar Date]={">=$(=Date(Monthstart(max([Calendar Date])), 'DD-MMM-YYYY')) <=$(=Date(MonthEnd(max([Calendar Date])), 'DD-MMM-YYYY'))"}>}[# QN Initiated])


Note: Replaced single quotes with double quotes (in red)

View solution in original post

4 Replies
tresesco
MVP
MVP

Try like:

sum({$<[Calendar Date]={">=$(=Date(Monthstart(max([Calendar Date])), 'DD-MMM-YYYY')) <=$(=Date(MonthEnd(max([Calendar Date])), 'DD-MMM-YYYY'))"}>}[# QN Initiated])


Note: Replaced single quotes with double quotes (in red)

nareshthavidishetty
Creator III
Creator III
Author

Hi,

What is the difference between these ',".

I'm getting same results as well.

Thanks..

tresesco
MVP
MVP

single quotes should be used for exact match, whereas double quotes for searching. In your expression, with double quotes, the error highlighting should go off. And since you have already said that you are getting the right result, that means same is correct one.

marcus_sommer

The best explaining is here: Quotes in Set Analysis.

- Marcus