4 Replies Latest reply: Sep 20, 2017 10:43 AM by Xavier HEMELAAR

Show all dimensions value at any time with calendar

Xavier HEMELAAR Sep 20, 2017 10:29 AM

Hi Qliker,

I have a little issue with my chart display. I used a canonical calendar to put 2 date dimensions on x-axis. If I have no selection then everything is displayed perfectly because each week is displayed in my chart:

But then if I make a selection on my DS_Number (it's like my ID number) the week in my calendar where there are no related data are removed from my chart (even selecting all my DS_Number):

Should I change the way the canonical Calendar works or is there another trick to make my chart display everything? I already trying show null value in dimension and also display Zero for measure...

QVF file is attached for better understanding.

Thanks for your support

CALENDAR TEST.qvf 288.0 K

Re: Show all dimensions value at any time with calendar

Sunny Talwar Sep 20, 2017 9:41 AM (in response to Xavier HEMELAAR )
Try by adding this to your expression

Count(if(DateType='Forecast', DS_Number)) + Avg({1} 0)

CALENDAR TEST.qvf 288.0 K
Like Show 0 Likes (0)

Actions
- Re: Show all dimensions value at any time with calendar
  
  Xavier HEMELAAR Sep 20, 2017 10:31 AM (in response to Sunny Talwar )
  
  Hi Sunny,
  
  Your solution worked perfect for a normal count as I showed in my initial exemple. But then I whanted to apply this same technique to accumalation.
  
  Test 1: rangesum( above( Count({$<DateType={'Target'}>} DS_Number),0,rowno()))+ Avg({1} 0)
  
  This also worked perfectly when I added a "if" condition:
  
  Test 2: IF(CanonicalWeek <= 38,rangesum( above( Count({$<DateType={'Target'}>} DS_Number),0,rowno()))+ Avg({1} 0))
  
  Result:
  
  But then if a set filter WP=CWB I have some gaps in my chart for measure that has the "IF" condition:
  
  I tried a few things but nothing helped... I changed QVF in original post to show this new case.
  
  CALENDAR TEST.qvf 288.0 K
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Show all dimensions value at any time with calendar
    
    Sunny Talwar Sep 20, 2017 10:32 AM (in response to Xavier HEMELAAR )
    
    May be try this
    
    If(Only({1} CanonicalWeek) <= 38, RangeSum(Above(Count({$<DateType={'Target'}>} DS_Number), 0, RowNo())) + Avg({1} 0))
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: Show all dimensions value at any time with calendar
      
      Xavier HEMELAAR Sep 20, 2017 10:43 AM (in response to Sunny Talwar )
      
      Perfect it solved my problem. I don't understand why but I will keep this syntaxe in my little "help list"
      
      Like Show 0 Likes (0)
      
      Actions

Go to original post