Passing dimension value in set analysis row by row

lionking15 — Wed, 15 Feb 2017 07:29:07 GMT

Hi guys

I want to develop above mentioned report.

Exp: Sum({<TransMonthName = {">=Max(MonthName) <=AddMonths(Max(MonthName),1)"}>}Sales)

Sales and TransMonthName fields are Table A

Month Name field is in Table B

Both the tables are linked via Key.

Problem: I want to pass each dimension value in set expression (">=Max(MonthName) <=AddMonths(Max(MonthName),1)"

For Example : Dimension value Nov 16 , Exp: Sum({<TransMonthName = {">=Nov 16<=Dec 16"}>}Sales)

Dimension value Dec16 , Exp: Sum({<TransMonthName = {">=Dec16<=jan 17"}>}Sales)

topic Passing dimension value in set analysis row by row in QlikView