Waterfall Chart in QlikView working slow

[supriyabiware]

Hi All ,

I have created a waterfall chart which somewhat looks like below

Dimension - Part number

Expression 1 - sum({$ <MonthYear={'$(=vUpdatedNextMonth_Calc)'}>}  SOURCING)- Display option - 'Bar'

Baroffset 1 - rangesum(above($(Expression 1),1,Rowno()))

Expression 2 - if(NOT isEntschieden, '+') & $(Expression 1)/MAX_SOURCINGNR & '%' - Display Option - 'nothing' , text only

Expression 3 -  $(Expression 1) - Display Option - 'nothing' , text only

#Expression 2 and 3 would be displayed conditionally one at a time .

What could possibly be slow here. only this chart is giving problem on tab enter and clear options 😞

Thanks,

Supriya.

[rodjager]

Hi,

There can be a lot of reasons why this is slow and it may not be the Waterfall chart but could be other expressions or objects in your model.  Also, it looks like you are referring to a variable so it would be helpful to see the variable definition too.

If you are able to put a sample on the site I think someone could give further suggestions, alternatively, I can recommend the Document Analzyer which does an excellent job of providing information to assist with this sort of issue:

https://community.qlik.com/t5/QlikView-App-Development/QlikView-Document-Analyzer-update-3-9/m-p/151...

Hope this helps.

Rod

[supriyabiware]

Hi,

Thanks for your reply.

variable i have used is nothing but an user entered month for seeing the chart.

vUpdatedMonth_Calc= Date(addmonths(Date(ReloadDate,'MM/YY'),vCounter_Month),'MM/YY')

vUpdatedNextMonth_Calc=Date(addmonths(Date(ReloadDate,'MM/YY'),vCounter_Month+1),'MM/YY')

vCounter_Month = is user clicked button variable which sets this variable as +1 or -1 or today , buttons are as below.

Also i have used Document analyser to identify that this chart gives me problem, but what would be solution for that would be the question.

Unfortunately i cannot add a sample qvw.

Thanks,

Supriya.

[supriyabiware]

there is one more expression i have used 'Text on Axis' just to highlight if possible selection has and open parts.

if(substringcount(GetFieldSelections([Part Number]),[Open Part Number])=1,'←',' ')

the chart is performing ok on filtered entry. but when 'clear' is pressed its very slow.

~40000ms 😞