topic Set Analysis in QlikView

Set Analysis

Mon, 27 May 2013 06:22:02 GMT

Hi Experts,

Can you correct the given expression ...

Year_Posting and Month_Posting are not working so getting 0 as my output.

Year_Posting , Year_Master_From , Year_Master_To

Month_Posting , Month_Master_From , Month_Master_To These are the fields. How to assign the field to other field. Getting wrong because of that only.

Kindly suggest.

=SUM( {<Year_Plan={$(vMaxYear)},Year_Posting={">=Year_Master_From <=Year_Master_To"},

Month_Posting={">=Month_Master_From) <=Month_Master_To)"},Month_Num_Plan={$(vMaxMonth)}, Flag_Plan={'ManuPlan'}>} Plan)

Gysbert_Wassenaar — Mon, 27 May 2013 09:14:23 GMT

My guess is that you're doing trying to compare fields on a record-by-record basis:

Year_Posting={">=Year_Master_From <=Year_Master_To"},

Month_Posting={">=Month_Master_From) <=Month_Master_To)"},

And that won't work. You'll have to replace those with if statements. Maybe something like:

SUM( {<Year_Plan={$(vMaxYear)},Month_Num_Plan={$(vMaxMonth)}, Flag_Plan={'ManuPlan'}>}

if (Year_Posting>=Year_Master_From and Year_Posting <=Year_Master_To and

Month_Posting>=Month_Master_From and Month_Posting <=Month_Master_To,

Plan))