How to make QS bar chart same like QV bar chart ?

[paulyeo11]

Hi All

I have 1 chart from QS another from QV , both have similar expression and dimension.

May i know how to make QS remove those bar which is from May 2017 - Dec 2017 ? Since QV does not display them , not sure why QS display those bar which is not necessary.

Above chart is from QV which is okay.

Below chart from QS is not okay.

[Anonymous]

You could use an if statement in your expression - if(YEARMONTH<DATE, Null(), YEARMONTH) - then make sure show nulls is not ticked.

[paulyeo11]

Hi Bella

I have try , but it still the same. In Qlik View it does not have any issue.

The reasons is i have sales target date for 2017 from jan till Dec , and they QS think that date are there.

Also my expression are quite complicated :-

(

money(

(RangeSum(Above(RangeSum

(Above(

Sum

(

{

<

year, month,sTOCK={sTOCK}

>

}

[Amount])/Rate, 0, RowNo()))),

-

Sum(

{

<

sTOCK={sTOCK}>

}

TOTAL Aggr(Sum(

{

<

year, month, sTOCK={sTOCK}

>

}

[Amount])/Rate, YearMonth

))))

, $(vMoneyFormatK))

)

Paul Yeo

[paulyeo11]

‌HI All

look like QV work fine because it have some hidden feature which QS does not have.

paul