Qlik sense chart

Arvind_07 — Tue, 30 Nov 2021 18:17:33 GMT

Hi All, I use the attached bar chart to visualize the measures by Weeks. These weeks is based on the fiscal calendar I updated as a direct table to my app.

Is it possible to view or differentiate the weeks dimension by showing which week falls under which month? lets say- WK18-WK21 are the weeks that fall under the Month of May. Is it possible for two dimensions exist at a same time in this bar chart? So that user can not only see the Weekly summary but also know at which month do these weeks belong to? Dimension- Rolling 13 weeks-=if(Date>= WeekStart(Today()-91) and Date<= WeekStart(Today()-7) , [Week Number]) Alternate Dimension- Month-=if(Date>= WeekStart(Today()-365) and Date<= WeekStart(Today()-7) , [Month])

Re: Qlik sense chart

Sammy_AK — Tue, 08 Jun 2021 20:17:06 GMT

logically this is not correct, you need to represent the dimension either in week or months because a week can have 2 months in it(i.e. it could be a end of the month and start of the another month), in this case how does the system decide which month to show.

you can try concatenating a dimension with Week, Month and Year and you shall see some week numbers will repeated for months.

topic Qlik sense chart in App Development

Qlik sense chart

Re: Qlik sense chart