Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ivandrago
Creator II
Creator II

Hide one of the Bar Charts if Values are the Same

Hi,

I have the attached Document.

I want to hide the No of Visits if the value is the same as the FTF bar value?

So for instance the ContactName "Tom Jones"  should only be showing the FTF bar as it is the same value as No of Visits,

Thanks

1 Solution

Accepted Solutions
sunny_talwar

Try this expression for FTF

If(Sum(FTF) = sum(VisitCount), 0, Sum(FTF))


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Try this expression for FTF

If(Sum(FTF) = sum(VisitCount), 0, Sum(FTF))


Capture.PNG

shiveshsingh
Master
Master

Hi

use this in expression for visitcount

f(sum(FTF)<>sum(VisitCount),sum(VisitCount),0)