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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
SK28
Creator II
Creator II
‎2023-06-16 02:57 AM

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

662 Views
0 Likes
2 Replies
brunobertels
Master
Master
‎2023-06-16 03:34 AM

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... 

651 Views
SK28
Creator II
Creator II
‎2023-06-16 04:18 AM
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

647 Views
0 Likes