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: 
vvvvvvizard
Partner - Specialist
Partner - Specialist

Ignore fields not working

I have to listboxes with field names MTH_SHORT_DESC and FIN_YR_NO . When i select 2018 for eg it shows 2018 data only , why is the ignoring of fields not working ? Ive done this before a 100 times 

 

(Sum({<MTH_SHORT_DESC=,FIN_YR_NO=>} Contribution) * Sum({<MTH_SHORT_DESC=,FIN_YR_NO=>}GL_VALUE) / count({<MTH_SHORT_DESC=,FIN_YR_NO=>}DISTINCT Cost_Centre)) / count({<MTH_SHORT_DESC=,FIN_YR_NO=>}distinct YR_MTH_NO)

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

What is vRounding in your expression? It seems like a variable, are you ignoring selection within that? If not, then that might be where you need to ignore selection....

View solution in original post

9 Replies
vvvvvvizard
Partner - Specialist
Partner - Specialist
Author

I also tried ignoring all selections

 

(Sum{1} Contribution) * Sum({1} GL_VALUE) / count({1}DISTINCT Cost_Centre)) / count({1}distinct YR_MTH_NO)

PrashantSangle

can you post your example or screenshot of it.

 

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
sunny_talwar

Did this work when you ignore everything? Or did this not work as well?

vvvvvvizard
Partner - Specialist
Partner - Specialist
Author

Nope , both doesnt work

vvvvvvizard
Partner - Specialist
Partner - Specialist
Author

 
sunny_talwar

What is vRounding in your expression? It seems like a variable, are you ignoring selection within that? If not, then that might be where you need to ignore selection....

vvvvvvizard
Partner - Specialist
Partner - Specialist
Author

Il try that , vrounding is a field which divides by 1 , 1000 , 1 billion , 

vvvvvvizard
Partner - Specialist
Partner - Specialist
Author

if i comment out vrounding it behaves how i want it to , seems like that is the problem 

sunny_talwar

Like I said, you need to ignore selection in the fields within the variable as well