topic Re: Filter issue in QlikView

Filter issue

noman212 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

Please help me to rectified my issue.

When i made a selection through filter and select individual name (Please find the attched snapshot for reference) , it returns correct values,

However, when i want to look overall values against Head field it return wrong percentage.

Please refer attachment.

As showing in 2 attachments the differ in values attacment 1 showing correct values.

i am using two dimension i.e grades and Head and using expression Count(Grades)

Please help me to resolve the same.

Regards

Noman khan

Re: Filter issue

Anil_Babu_Samineni — Wed, 24 Apr 2019 07:13:07 GMT

As you said, first image it will take correct values due to you are using one dimension where as second measure you did it for second dimension. What your intend here?

Re: Filter issue

noman212 — Wed, 24 Apr 2019 07:21:00 GMT

No the dimensions and measures are same in both pic, but when i made seletion to head field and select single person as mentioned (Fawad Ahmed Farooqui) its represents corrects values due to it bifurctaes data according to fawad's Hierarchy and dividing with total with only who's belong to Fawad's hierarchy.

But when undo selection it divide the values with overall count(Which is not belongs to fawad and other hierarchy) which is incorrect.

Re: Filter issue

noman212 — Wed, 24 Apr 2019 07:34:04 GMT

i want a generic expression against each Head which bifurcate data according to their hierarchies.

Re: Filter issue

noman212 — Wed, 24 Apr 2019 08:05:40 GMT

Any one ?

Re: Filter issue

jonathandienst — Wed, 24 Apr 2019 08:09:12 GMT

The values are correct. When no head is selected, the % is based on all the bars/heads. If you want % by head on the second view, you will need to create another expression with the % by head (something like Sum(TOTAL <head> ....)). Use a combo chart and you can turn off bars/lines and turn on the label option. Turn off pop-ups and labels for the other expression.

Re: Filter issue

noman212 — Wed, 24 Apr 2019 11:05:31 GMT

Thank you for your reply. its working fine now.