Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I do this graphic?

Hi everyone!

First of all, sorry for my english.

Well, I just started to develop in qlikview and I don´t know how to do this graphic.

I´ve got an excel table with this fields: ID (client ID) p2(can only have the values 1 or 2) and 12 fields more, each one represents  month. If the client answered the question in January, then the field 1 has a 1 and it has null if he didn´t. I know that it´s an horrible DB, but this is what I have.

Well, I need to create a bar graphic that has to show 12 bars, one per month with the percent of people that in this month answered 1.

I attach an excel file that is similar to the excel I have.

Thanks a lot.

2 Replies
m_woolf
Master II
Master II

Is this what you wanted?.

Not applicable
Author

not exactly, but you gave me a tip.

Thank you very much.