Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
farheenayesha
Creator
Creator

Issue with the waterfall model

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.

Waterfall Model.JPG

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#))



1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

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

View solution in original post

2 Replies
Clever_Anjos
Employee
Employee

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

farheenayesha
Creator
Creator
Author

Thank you so much Clever.