topic How to make QS bar chart same like QV bar chart ? in App Development

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

paulyeo11 — Sun, 28 May 2017 05:57:14 GMT

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.

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

Anonymous — Sun, 28 May 2017 19:54:31 GMT

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

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

paulyeo11 — Sun, 28 May 2017 22:21:47 GMT

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

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

paulyeo11 — Mon, 29 May 2017 22:44:55 GMT

‌HI All

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

paul