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: 
Karahs
Partner - Creator
Partner - Creator

Qs- Values reflecting

Hello everyone,

So my question is that as seen in the below images the value in the cost column is reflecting while selecting some zone . The formula which i have used for Cost Column is :

(92000/(Count(Total{<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])))*Count({<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])

What should i do to not reflect the values? Is there any alternative way?

Untitled.png

  Untitled1.png

1 Solution

Accepted Solutions
sunny_talwar

Try this:

(92000/(Count(Total{<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}, Zone>}[Client Code])))*Count({<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])

View solution in original post

6 Replies
sunny_talwar

So you mean that value should not change based on selection in Zone Field? Try this may be

(92000/(Count(Total{<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}, Zone>}[Client Code])))*Count({<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}, Zone>}[Client Code])

Karahs
Partner - Creator
Partner - Creator
Author

Hey,

It is kind of working, but it is affecting the totals column as u can see in the below image and Zone is not getting selected.Untitled3.png

sunny_talwar

Not sure I follow the issue. What is wrong with Total? Extra rows?

Karahs
Partner - Creator
Partner - Creator
Author

Hey ,

Can u find the difference in both the images?? When i select a specific zone it shows all the elemnts in that zone column, the selection which m doing is not getting specificaly selected.

Untitled4.png

sunny_talwar

Try this:

(92000/(Count(Total{<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}, Zone>}[Client Code])))*Count({<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])

Karahs
Partner - Creator
Partner - Creator
Author

Thankyou so much it worked