Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
matthewlau120
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:Screen Shot 2019-02-13 at 3.44.06 PM.png

Screen Shot 2019-02-13 at 3.44.29 PM.png

 

1 Solution

Accepted Solutions
pradosh_thakur
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
pradosh_thakur
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.
pradosh_thakur
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.