topic set analysis newbie in QlikView

set analysis newbie

james_wynn — Fri, 20 Nov 2020 18:02:30 GMT

I have my Master_Dates table in the datamodel with no synthetic joins; it is unaffiliated. I want to sum(ST_Amt) using set analysis and will place a Listbox in the dashboard with the field Fiscal_Week_Year to be used making the selection:

The code below returns null or zero$s, Itm_Dt is in the main detail table and Week_End is in the Master_Dates table. I am using algebraic expression < = which is probably incorrect. Can you help with a suggestion?

sum({$< Itm_Dt < = Week_End> ST_Amt})

set analysis newbie

Mon, 07 Feb 2011 17:46:39 GMT

Hi,

Try the following,

Sum({$<Itm_Dt={<=Week_End}>}ST_Amt)

This may not work depending on the values in the referenced fields, but give it a try.

Thanks

Nick

AW:Re: set analysis newbie

brenner_martina — Mon, 07 Feb 2011 18:58:57 GMT

Hi,

that's nearly good, but not enough

Sum({$<Itm_Dt={"$(<=Week_End)"}>} ST_Amt)

set analysis newbie

hector — Mon, 07 Feb 2011 19:07:45 GMT

my version is

sum({$< Itm_Dt = {"<=$(=Max(Week_End))"}>} ST_Amt)

So, if you don't have selections in the week_end field, at least it will return the max value in it.

Rgds

AW:Re: set analysis newbie

james_wynn — Mon, 07 Feb 2011 19:37:12 GMT

Martina,

Your code above returns all zeros.

I also have:

Balance:
Sum({<Itm_Dt<={'$(Week_End)'}>} ST_Amt )

Balance Resolved
Sum({<Date_Resolved<={$(=Week_End)}>} ST_Amt )

Both return all rows summed; ie, no selection is being made... the fiiedls are all populated the issue is in the set analysyis. Can you help?

Thanks for your prompt post!

🙂
Jim

AW:Re: set analysis newbie

johnw — Tue, 08 Feb 2011 02:45:23 GMT

Héctor's code looks right to me. Did you try it? Did it return nothing as well?