Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RutiTaumanRubin
Creator
Creator

Missing Period in Chart - QlikSnese

Hi,

I Create line chart with 2 dims (Quarter and area) and 1 measure .

I had a filter in the measure that will display the last 3 quarter:

count({$<Quarter={'$(=$(V_Max_1_Q))','$(=$(V_Max_2_Q))','$(=$(V_Max_3_Q))'}>}Tests)

I want that the chart will display always 3 quarters even there is no data in one of the quarter (display with value 0 ). Currently, it shows only the quarters with data (attach example).

Any Idea?

Thank you!

4 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Ruti,

Please do as follows:

In properties -> Dimension-> Check Display all Data checkbox and  uncheck suppress value is null.

Thanks,

Arvind Patil

RutiTaumanRubin
Creator
Creator
Author

Thank you for your response..

The Dims marked with option of Show null value and no limitation but the quarter still does not appear ..

I think it related to the filter in the Measure:

count({$<Quarter={'$(=$(V_Max_1_Q))','$(=$(V_Max_2_Q))','$(=$(V_Max_3_Q))'}>}Tests)

shraddha_g
Partner - Master III
Partner - Master III

How you have defined variables V_Max_1_Q,V_Max_2_Q,V_Max_3_Q?


Try,


count({$<Quarter={'$(=V_Max_1_Q)','$(=V_Max_2_Q)','$(=V_Max_3_Q)'}>}Tests)

RutiTaumanRubin
Creator
Creator
Author

Hi,

It's define :

SET V_Max_1_Q="maxstring(Quarter)";

!