Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

RutiTaumanRubin
Contributor

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
Valued Contributor III

Re: Missing Period in Chart - QlikSnese

Hi Ruti,

Please do as follows:

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

Thanks,

Arvind Patil

RutiTaumanRubin
Contributor

Re: Missing Period in Chart - QlikSnese

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
Honored Contributor III

Re: Missing Period in Chart - QlikSnese

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
Contributor

Re: Missing Period in Chart - QlikSnese

Hi,

It's define :

SET V_Max_1_Q="maxstring(Quarter)";

!

Community Browser