topic Re: Set analysis issue in QlikView

Set analysis issue

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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])

Thanks..

Re: Set analysis issue

tresB — Wed, 07 Feb 2018 08:51:19 GMT

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)

Re: Set analysis issue

nareshthavidishetty — Wed, 07 Feb 2018 09:01:09 GMT

Hi,

What is the difference between these ',".

I'm getting same results as well.

Thanks..

Re: Set analysis issue

tresB — Wed, 07 Feb 2018 09:09:50 GMT

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.

Re: Set analysis issue

marcus_sommer — Wed, 07 Feb 2018 09:12:04 GMT

The best explaining is here: Quotes in Set Analysis.

- Marcus