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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
SK28
Creator II
Creator II

I have Nested Multiple(like Pivot) Columns and the Values, Can we make this into straight table in datamodel

Hi

I have a data like this I want to count the status(Complete,Incomplete) of their respective , Need help in creating a data model into a straight table

 

Sample Data:

id

Application ABC
1.1.1 1.1.2 1.1.3 1.1.4 1.1.5 1.2.1 1.2.2 1.2.3 1.2.4 1.2.5 1.2.6 1.2.7
SCOPE ASSESMENT Internal REVIEW Review L Info Gathering Identify Primary Complete Registration Validate Database  Create  accounts Accounts in ABC  Data Profiling Access Governance
123 Complete Incomplete Complete Incomplete Incomplete NA Complete Incomplete Complete Incomplete Incomplete NA
124 Complete Incomplete Complete Incomplete Incomplete Complete Complete Incomplete Complete Incomplete Incomplete Complete
125   Incomplete Incomplete Incomplete Incomplete NA   Incomplete Incomplete Incomplete Incomplete NA
126 Complete Incomplete Complete NA Complete Complete Complete Incomplete Complete NA Complete Complete
127 Complete Incomplete Complete Incomplete Incomplete NA Complete Incomplete Complete Incomplete Incomplete NA
128 NA Incomplete NA Incomplete Incomplete NA NA Incomplete NA Incomplete Incomplete NA
129 Complete Incomplete Complete Incomplete Incomplete Incomplete Complete Incomplete Complete Incomplete Incomplete Incomplete
130 Complete Incomplete Incomplete complete Incomplete NA Complete Incomplete Incomplete complete Incomplete NA
131 Complete Incomplete Complete Incomplete Complete NA Complete Incomplete Complete Incomplete Complete NA
132 Complete Incomplete Complete Incomplete Incomplete NA Complete Incomplete Complete Incomplete Incomplete NA

 

Need a model on the above sample data

2 Replies
brunobertels
Master
Master

Hi 

See this post as an example on how to load excel cross table with multiple header 

https://community.qlik.com/t5/QlikView-App-Dev/CrossTable-from-Excel-with-Multiple-Headers/td-p/9308... 

SK28
Creator II
Creator II
Author

Thanks for the response, Can you please Help me with the Model, I have 3 Nested here, 
1) Application

2) Version

3) Stage

Can anyone write a code on this that would be helpful