Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Waterfall Chart in QlikView working slow

Hi All ,

I have created a waterfall chart which somewhat looks like below

Capture.PNG

Capture.PNG

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.

Labels (1)
3 Replies
Highlighted
Partner
Partner

Re: Waterfall Chart in QlikView working slow

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

Highlighted
Creator
Creator

Re: Waterfall Chart in QlikView working slow

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.

Capture.PNG

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.

 

 

 

Highlighted
Creator
Creator

Re: Waterfall Chart in QlikView working slow

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 😞