Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help Required Design Reports & Heat Map

Hi All,

I am new to Qlikview, actually I started using it yesterday. I have a request to create Dashboard and I thought Qlikview will be the ideal as part of Our Proof of concept.

I have a file which list all the colums tested per record, and we would like to create graphs, showing the number of invalids per column as well as another graph showing the clean ones. We will then monitor the progress in terms of rectifying issues highlighted on a weekly basis.

My file structure is as below. Please let me know how I can develop this in Qlikview, as I have one table only that has the dimension and facts.

Table

"REPORTDATE"

"CUSTOMERTYPE"

"ACCOUNT_ID"

"SERVICE_NO"

"ACCOUNT_NO"

"BAN"

"AREA"

"SEGMENTATION"

"SERVICE"

"INVALIDID"

"INVALIDINITIALS"

"INVALIDFIRSTNAME"

"INVALIDLASTNAME"

"INVALIDPHONEHOME"

"INVALIDHOMEMOBILE"

"INVALIDHOMEEMAIL"

"INVALIDWORKEMAIL"

"CONTACTEXISTENCE"

"INVALIDWORKMOBILE"

"INVALIDPHONEWORK"

"XBILLINGEMAIL"

Sample Data Attached...

Thanks...

0 Replies