Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

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

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.

QV STOCK.png

Above chart is from QV which is okay.

Below chart from QS is not okay.

QS STOCK.png

3 Replies
bellamae
Valued Contributor

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

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

paulyeo11
Valued Contributor II

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

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

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

‌HI All

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

paul