topic Re: Set Analysis Syntax in QlikView

Set Analysis Syntax

Anonymous — Wed, 17 Sep 2014 12:43:02 GMT

Hello All,

Can anybody suggest what is wrong in this following syntax?

=sum({$<[Posting Date] = {"<=$(=VPostYear,=VPostMonth)"}, Clearing_Date= {">=$(=VPostYear,=VPostMonth)"}>} [Amount in LC])

Please suggest.

Regards,

Balraj

Re: Set Analysis Syntax

Gysbert_Wassenaar — Wed, 17 Sep 2014 12:51:38 GMT

This part doesn't make sense to me: $(=VPostYear,=VPostMonth). If Posting Date is a date then you should have a date on the right hand of the <=. Perhaps $(=makedate(VPostYear,VPostMonth)).

Re: Set Analysis Syntax

Anonymous — Wed, 17 Sep 2014 13:01:16 GMT

Gysbert,

I am not making any date here, I have a field Posting Date and I am comparing Posting Date with the selected year and month.

For me it seems, there is syntax error in Set analysis the way I am comparing.

Example: Say if user is selecting a Year and a Month, now I want to load that data only whose posting date was less than or equal to selected year and month, and whose Clearing Date is greater than or equal to selected year and month.

Could you help to make it correct?

Re: Set Analysis Syntax

Gysbert_Wassenaar — Wed, 17 Sep 2014 13:07:25 GMT

Example: Say if user is selecting a Year and a Month, now I want to load that data only whose posting date was less than or equal to selected year and month, and whose Clearing Date is greater than or equal to selected year and month.

Use the makedate function to create a date from the selected year and month so that date value can be compared with the date values in your Posting Date field. MakeDate(2014,9) will create the first of september 2014 as date value. A date value like that can be used to compare other dates with to check if they come before or after it.

Re: Set Analysis Syntax

Anonymous — Wed, 17 Sep 2014 13:11:20 GMT

okay,

Let me try this.