Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
a_shetty
Contributor
Contributor
‎2020-04-02 01:39 PM

Stacked Bar Chart

Hello Experts!

I am struggling to have this particular data in my stacked bar chart

I have 2 dimensions 'Categories' and 'Week Num' which are stacked against the measure 'AWO'. I want only the data for 'Friday' of each week to be displayed and when in current week, the current dates Data has  to be displayed .

I did it by creating Master dimension =If([Weekly Data]='Fri',[Week Num]) which works fine till week 13. How do I include Todays Data(02/04/2020) in week 14 column?

Also For Category whose value is 'Closed', I want to have cumulative sum in the same chart. Is it possible to do this?

Stacked Bar.jpg

Labels (1)
Labels

  • SaaS

253 Views
0 Likes
0 Replies