Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

data formating

Hello All,

Could someone help me, how could i format the excel data like below image format. kindly help me i would like to format attached excel data below image format.

Untitled.png

Regards,

Navin

Labels (3)
2 Solutions

Accepted Solutions
Frank_Hartmann
Master II
Master II

see attached.

hope this helps

View solution in original post

Frank_Hartmann
Master II
Master II

see attached qvw

hope this helps

View solution in original post

16 Replies
NavinReddy
Creator II
Creator II
Author

kindly help me with the suggestions 

Frank_Hartmann
Master II
Master II

see attached.

hope this helps

NavinReddy
Creator II
Creator II
Author

Thanks a lot for your help.  

NavinReddy
Creator II
Creator II
Author

Thanks a lot for your help

NavinReddy
Creator II
Creator II
Author

@Frank_Hartmann

sorry if i want to implement same logic with dynamic data, how could i implement, my data will changes based on selection, kindly help me. 

Frank_Hartmann
Master II
Master II

can u share a sample qvw and a description of the expected behaviour?

NavinReddy
Creator II
Creator II
Author

@Frank_Hartmann sorry for my later reply,

i have added the sample data, i was not able to implement your logic. kindly help me 

Frank_Hartmann
Master II
Master II

How do you determine which header to use for the ID´s?  is there any logic how you assign the IDs to the headers. How many Headers do you need?

NavinReddy
Creator II
Creator II
Author

i want to disply all the list of IDs belongs to the header, we already have mapping. i would like to disply based on header assinged ids. Header under list of IDs.