Week day condition on working in if condition Qlik Sense

[UserID2626]

Hi,

I am trying to keep Month,Day& week in same chart with if condition.

Inline script:

Load * Inline

[

Charts

Day

Week

Month

];

Dimension:

If(wildmatch(Charts,'Month'),Month(dt),if(Wildmatch(Charts,'Week'),Weekday(dt),day(dt)))

Given Charts as filter, based on selection of filter dimension will work,

Issue is when selecting week is not showing weekday properly, its showing like jun,sun,mon(refer below image).

As per my requirement alternate dimension will not work properly. help me to resolve this weekday.

How to resolve.

[shanemichelon · Accepted solution]

You need to wrap your dimension in an aggregate:

=aggr(
  If(wildmatch(Charts,'Month'),
     Month(dt),
     if(Wildmatch(Charts,'Week'),
       Weekday(dt),
       Day(dt)
       )
     ),
  dt
  )