topic Re: Ignore fields not working in QlikView

Ignore fields not working

vvvvvvizard — Mon, 24 Jun 2019 09:46:11 GMT

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)

Re: Ignore fields not working

vvvvvvizard — Mon, 24 Jun 2019 09:50:32 GMT

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

PrashantSangle — Mon, 24 Jun 2019 09:57:22 GMT

can you post your example or screenshot of it.

Regards,

Re: Ignore fields not working

sunny_talwar — Mon, 24 Jun 2019 11:35:48 GMT

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

Re: Ignore fields not working

vvvvvvizard — Tue, 25 Jun 2019 08:14:05 GMT

Nope , both doesnt work

Re: Ignore fields not working

vvvvvvizard — Tue, 25 Jun 2019 10:44:36 GMT

Re: Ignore fields not working

sunny_talwar — Tue, 25 Jun 2019 11:02:21 GMT

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....

Re: Ignore fields not working

vvvvvvizard — Tue, 25 Jun 2019 13:26:03 GMT

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

Re: Ignore fields not working

vvvvvvizard — Tue, 25 Jun 2019 13:30:03 GMT

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

Re: Ignore fields not working

sunny_talwar — Tue, 25 Jun 2019 13:56:48 GMT

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