Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

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
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

592 Views
0 Likes
0 Replies