Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kshitijas
New Contributor III

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

Re: Qs- Values reflecting

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

6 Replies

Re: Qs- Values reflecting

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

kshitijas
New Contributor III

Re: Qs- Values reflecting

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

Re: Qs- Values reflecting

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

kshitijas
New Contributor III

Re: Qs- Values reflecting

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

Re: Qs- Values reflecting

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

kshitijas
New Contributor III

Re: Qs- Values reflecting

Thankyou so much it worked

Community Browser