Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
vvvvvvizard
Contributor III

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

Re: Ignore fields not working

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
Contributor III

Re: Ignore fields not working

I also tried ignoring all selections

 

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

Re: Ignore fields not working

can you post your example or screenshot of it.

 

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.

Re: Ignore fields not working

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

vvvvvvizard
Contributor III

Re: Ignore fields not working

Nope , both doesnt work

vvvvvvizard
Contributor III

Re: Ignore fields not working

 

Re: Ignore fields not working

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

vvvvvvizard
Contributor III

Re: Ignore fields not working

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

vvvvvvizard
Contributor III

Re: Ignore fields not working

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

Re: Ignore fields not working

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