Qlik Sense App Development

New Contributor

Fliter Regard to only one dimension selection

Hi All

My question is about how to set up a set analysis formula regard to only "Outlet Dimension" in the below picture.

I need to calculate the MTD Value by each outlet. However, the MTD value is now aggregated but not in separate outlet  .

Here is the formula and the pic:

formula:=Sum({1<[check_time.autoCalendar.Year]={"\$(=(year(Max(check_time))))"},[check_time.autoCalendar.Date]={">=\$(=(MonthStart(Max(check_time))))<=\$(=date(Max(check_time)))"}>}total_amt)

Now the JR and HC MTD Value is the same

Pic and Fliter Panel:

1 Solution

Accepted Solutions
Highlighted
Honored Contributor II

Re: Fliter Regard to only one dimension selection

For the selection to work

`=Sum({1<[check_time.autoCalendar.Year]={"\$(=(year(Max(check_time))))"},[check_time.autoCalendar.Date]={">=\$(=(MonthStart(Max(check_time))))<=\$(=date(Max(check_time)))"},[Outlet Name]=p([Outlet Name])>}total_amt)`
Learning never stops.
2 Replies
Honored Contributor II

Re: Fliter Regard to only one dimension selection

for out let JR

`=Sum({1<[check_time.autoCalendar.Year]={"\$(=(year(Max(check_time))))"},[check_time.autoCalendar.Date]={">=\$(=(MonthStart(Max(check_time))))<=\$(=date(Max(check_time)))"},[Outlet Name]={'JR'}>}total_amt)`

for HC

`=Sum({1<[check_time.autoCalendar.Year]={"\$(=(year(Max(check_time))))"},[check_time.autoCalendar.Date]={">=\$(=(MonthStart(Max(check_time))))<=\$(=date(Max(check_time)))"},[Outlet Name]={'HC'}>}total_amt)`
Learning never stops.
Highlighted
Honored Contributor II

Re: Fliter Regard to only one dimension selection

For the selection to work

`=Sum({1<[check_time.autoCalendar.Year]={"\$(=(year(Max(check_time))))"},[check_time.autoCalendar.Date]={">=\$(=(MonthStart(Max(check_time))))<=\$(=date(Max(check_time)))"},[Outlet Name]=p([Outlet Name])>}total_amt)`
Learning never stops.