topic Re: Filtering isn't working in QlikView

Filtering isn't working

Tue, 22 Jul 2014 13:47:04 GMT

why I cannot filter? In the chart "Conteggio Articoli Campionati" if I filter and article (i.e. 9ODO60147) the filter doesn't apply...can someone explain me why???

Re: Filtering isn't working

stigchel — Tue, 22 Jul 2014 13:49:39 GMT

Do you have section access on NTNAME on the document? I can not open it...

Re: Filtering isn't working

avinashelite — Tue, 22 Jul 2014 13:51:13 GMT

We are not able to open the document

Re: Filtering isn't working

ashfaq_haseeb — Tue, 22 Jul 2014 13:52:00 GMT

Hi,

I cannot open your file.

Regards

ASHFAQ

Re: Filtering isn't working

Tue, 22 Jul 2014 13:52:10 GMT

how can I check that? is there a way to make it accessible to everyone?

Re: Filtering isn't working

julian_rodriguez — Tue, 22 Jul 2014 13:54:16 GMT

Check on the script and find the sentence "Section Access"...

Re: Filtering isn't working

avinashelite — Tue, 22 Jul 2014 13:54:41 GMT

Hi,

Please check in your script or hidden script, if you see anything like section access and section application please delete it and reload the file again and upload it.

Re: Filtering isn't working

Giuseppe_Novello — Tue, 22 Jul 2014 14:24:34 GMT

Irene,

Not sure if you replace the document, bc I can open it. Anyways, your main problem is that you have Synthetic keys all over your data structure that might cause issues and bad results, you must first fix those. To check the data structure only open the document and hit " CTRL + T" data structure windows opens and on top you'll see "Auto-Layout" to have a better view.

Re: Filtering isn't working

Tue, 22 Jul 2014 15:10:03 GMT

the file can be open now?

Re: Filtering isn't working

Giuseppe_Novello — Tue, 22 Jul 2014 15:11:32 GMT

I guess, I can open it fine. 😃

Re: Filtering isn't working

julian_rodriguez — Tue, 22 Jul 2014 21:41:49 GMT

Found it!!

On the expression "Qtà" says:

=Count ({<[Codice Articolo]>} [QTA 1 Campionature])

The set analisys is ignoring all the selections made on the field "Codice Articolo"

You should use instead:

=Count ([QTA 1 Campionature])

Regards

Hello Irene

Could you try please, create one field named for example "Codice Articolo 2", with the same definition of "Codice Articolo"?

I have seen this before, and I have needed to change the field name, with any reason or knowing why.

Regards

Re: Filtering isn't working

Mon, 28 Jul 2014 14:58:49 GMT

I liked your answer but I need to calculate the QTA1_Campionature with respect to the 'Codice Articolo' variable. If I remove it as you suggested it gives me a wrong result.

Re: Filtering isn't working

Mon, 28 Jul 2014 15:03:03 GMT

My apologies @Julian Rodriguez. I didn't filter correctly, the result is the same! thank you very much for your help!

Re: Filtering isn't working

julian_rodriguez — Mon, 28 Jul 2014 15:45:55 GMT

You are very welcome Irene!

Regards!