Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to create this same excel in QV

Hi All,

Please can some one show me how to create this same excel in QV. attaching the excel. I need to join this excel with the ID column with another excel i have. Please help to create the same format.

 

QASITDev
BusinessIDScountAnn CostSter CostScountAnn CostSter CostScountAnn CostSter Cost
Abc11001800030040010000104002100030
def2200210005007003100020010006100070
lmn3300240007001000320003901600101000110
son4400270009001300430005802200141000150
xyz55003000011001600540007702800181000190
takl66003300013001900650009603400221000230
mota770036000150022007600011504000261000270
raks880039000170025008700013404600301000310
tild990042000190028009800015305200341000350

Thanks for your help.

7 Replies
Anonymous
Not applicable
Author

please see the attached app. let me know if you need anything else

Anonymous
Not applicable
Author

Thanks. But sorry i didn't get you. How the format will appear as QA ,SIt and DEV and then below that their respective column. Your application output doesn't show the same.

Sorry. please can you help

Anonymous
Not applicable
Author

now how about the attached

Anil_Babu_Samineni

I have one doubt. This time we have three only. Sometimes, we do have 20 Testing then we required to add 20 times using Concatenate manually.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anil_Babu_Samineni

Can i know is this in Qlikview / Qlik sense

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Its QlikView. you are write, i have given example as 3 column but there are 7 in all as of now.

Anonymous
Not applicable
Author

ankitd_modi

does my solution did not help you