topic Set analysis and current expression in QlikView

Set analysis and current expression

Fri, 09 Aug 2013 16:35:43 GMT

Hi, I have a straight table by vendorID and sales of the last three months, for this i m using this set_analysis:

sum({1<

Date={">=$(=Date(AddMonths(Max(Date),-$(VarMonthsAccum)+1)))"}>} SALES)

VarMonthsAccum (VARIABLE = 3)

when i select a vendorID, the table is kept without changing, my problem is that I NEED that only the vendorID line was shown, how could i do that?

Thanks in advance.

Re: Set analysis and current expression

Gysbert_Wassenaar — Sat, 10 Aug 2013 17:31:08 GMT

sum({1<Date={">=$(=Date(AddMonths(Max(Date),-$(VarMonthsAccum)+1)))"}>} SALES)

That 1 means that all selections are disregarded. So your selection of vendorID is ignored in the expression.

You can replace the 1 with only those fields for which you want the selections to be disregarded. The below expression for example would disregard only selections in the fields MyDim1 and MyDim2:

sum({<MyDim1=,MyDim2=, Date={">=$(=Date(AddMonths(Max(Date),-$(VarMonthsAccum)+1)))"}>} SALES)

If you do not want the expression to ignore selections then you can simply leave out the 1:

sum({< Date={">=$(=Date(AddMonths(Max(Date),-$(VarMonthsAccum)+1)))"}>} SALES)

Re: Set analysis and current expression

VishalWaghole — Sun, 11 Aug 2013 06:26:38 GMT

Try this

sum({$<Date = {">=$(=Date(AddMonths(Max(Date),-3),'MM-DD-YYYY'))"}>}Sales)

Hope it will work

Thanks

Re: Set analysis and current expression

Mon, 12 Aug 2013 16:13:13 GMT

That was exactly what was happening, now i delete the "1" and add the field I want to be ignored (PERIOD_NAME)

sum({<Date={">=$(=Date(AddMonths(Max(Date),-$(VarMonthsAccum)+1)))"},PERIOD_NAME=>} SALES)

Thank you!!