topic Re: Waterfall Chart in QlikView working slow in QlikView

Waterfall Chart in QlikView working slow

supriyabiware — Sat, 16 Nov 2024 21:42:53 GMT

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.

Re: Waterfall Chart in QlikView working slow

rodjager — Wed, 19 Dec 2018 20:31:12 GMT

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/1519546#M437383

Hope this helps.

Rod

Re: Waterfall Chart in QlikView working slow

supriyabiware — Thu, 20 Dec 2018 09:04:03 GMT

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.

Re: Waterfall Chart in QlikView working slow

supriyabiware — Thu, 20 Dec 2018 09:07:55 GMT

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 😞