Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to display each country population with expression in Qlikview?

hi ,

I created Drill Down in Qlik view I want to display Each country population in my chart i do not know how to display country wise population with expression.please tell me out how to disply country wise in chart . I Attached snipping files below this box.

           Thanks

Regards:

Madhu

7 Replies
Anonymous
Not applicable
Author

You may have to use Count function instead of Sum.

Count(ID)

aveeeeeee7en
Specialist III
Specialist III

See the Snapshot and check the Values on Data Points in Expression:

check this.bmp

Also, see the Attachment.

Regards

Aviral Nag

Not applicable
Author

I followed your expression but  the date is not displayed in my chart Nag aviral.ple tell me how to display data  in my chart.

aveeeeeee7en
Specialist III
Specialist III

Please Attach your file.

Not applicable
Author

Nag aviral I attached my file above my box that DD7 and DD8 snipping files.ple see and replay

aveeeeeee7en
Specialist III
Specialist III

From the Attached images, i am not able to help you out. Can you Attach your Application so that i can understand your data and answer you in a better way.

chematos
Specialist II
Specialist II

Please, let us know how is your model. Do you have the CountryID and Population in the same table? If you don´t, you need to join tables using key fields. Assuming you have CountryID in one table and Population in other table, you would need to have CountryID and Population in the same table so you can join the data, if you don't, your data will have no relation and you will not be able to do calculations over your dimensions.

Attach your file or a print screen of your model at least so we can help you

Regards