Issue with the waterfall model

farheenayesha — Tue, 12 Nov 2013 11:23:44 GMT

My waterfall model is flying in air as you can see in the below picture. Please someone help me to start the bars of the chart from the axis line.

I have used the below expression:

Total: Count (DISTINCT QUOTE#)

Bar offset:No exp( as this is the first expression)

1st level: count (DISTINCT if(CPG_APPROVAL_LEVEL=1,QUOTE#))

Bar offset:Count (DISTINCT QUOTE#)-count(DISTINCT if(CPG_APPROVAL_LEVEL=1,QUOTE#))

2nd level: count (DISTINCT if(CPG_APPROVAL_LEVEL=2,QUOTE#))

Bar offset:Count (DISTINCT QUOTE#)-count(DISTINCT if(CPG_APPROVAL_LEVEL=1,QUOTE#))-count(DISTINCT if(CPG_APPROVAL_LEVEL=2,QUOTE#))

3rd level: count (DISTINCT if(CPG_APPROVAL_LEVEL=3,QUOTE#))

Bar offset:Count (DISTINCT QUOTE#)-count(DISTINCT if(CPG_APPROVAL_LEVEL=1,QUOTE#))-count(DISTINCT if(CPG_APPROVAL_LEVEL=2,QUOTE#))-count(DISTINCT if(CPG_APPROVAL_LEVEL=3,QUOTE#))

4th level:count (DISTINCT if(CPG_APPROVAL_LEVEL=4,QUOTE#))

Bar offset: Count (DISTINCT QUOTE#)-count(DISTINCT if(CPG_APPROVAL_LEVEL=1,QUOTE#))-count(DISTINCT if(CPG_APPROVAL_LEVEL=2,QUOTE#))
- count(DISTINCT if(CPG_APPROVAL_LEVEL=3,QUOTE#))- count(DISTINCT if(CPG_APPROVAL_LEVEL=4,QUOTE#))

Re: Issue with the waterfall model

Clever_Anjos — Tue, 12 Nov 2013 11:30:24 GMT

Set Static Min to 0 and "Forced 0" at Axes tab

Re: Issue with the waterfall model

farheenayesha — Tue, 12 Nov 2013 12:45:58 GMT

Thank you so much Clever.

topic Issue with the waterfall model in QlikView

Issue with the waterfall model

Re: Issue with the waterfall model

Re: Issue with the waterfall model