Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
noman212
Creator III
Creator III

Filter issue

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, 

1.png

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

Please refer attachment.

2.png

 

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

1 Solution

Accepted Solutions
jonathandienst

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

6 Replies
Anil_Babu_Samineni

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
noman212
Creator III
Creator III

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.

noman212
Creator III
Creator III

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

Any one ?

jonathandienst

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

noman212
Creator III
Creator III

Thank you for your reply. its working fine now.