topic Re: problem with set analysis in Management & Governance

problem with set analysis

zied_ahmed1 — Mon, 13 Aug 2018 09:36:05 GMT

Hello,

I would lik when i select a Month i will have the sum of CAT from the start of year to Month selected :

For example if i select April i will do sum of January,February,March,April of sum (Sales)

Thanks for help

arvind_patil — Mon, 13 Aug 2018 09:45:08 GMT

Hi Zied,

Your Set analysis may be like below:

Sum({<Date={'>= $(=YearStart(max(Date))) <= $(=max(Date))'},Month=>}Sales)

Thanks,

Arvind Patil

shraddha_g — Mon, 13 Aug 2018 09:45:53 GMT

try this,

sum({<Date = {">=$(=date(Yearstart(Max(Date))))<=$(=Date(max(Date)))"},Month=>}CAT)

zied_ahmed1 — Mon, 13 Aug 2018 09:54:44 GMT

Hello,

I will explain more the requirement :

If I select June i will have the sum Sales of A16-06 (06 is the June ) and 05 and 06 of the field CAT

arvind_patil — Mon, 13 Aug 2018 10:14:14 GMT

Hi Zied,

At the time of selection of month june your max date is jun 18.

sum({<Date = {">=$(=date(Yearstart(Max(Date))))<=$(=Date(max(Date)))"},Month=>}CAT)

Yearstart gives you from jan to june.

Thanks,

Arvind patil

shraddha_g — Mon, 13 Aug 2018 10:22:01 GMT

what is the year in this case?

Create a date field and then use that set expression mentioned in previous comment.

BalaBhaskar_Qlik — Mon, 13 Aug 2018 14:20:57 GMT

May be this:

Sum({<Month = {"$(='>=1<=' & Num(Month(Max({1}Date))))"}, Year>} Sales)

BalaBhaskar_Qlik — Mon, 13 Aug 2018 14:29:57 GMT

Refer this: