topic Re: How to create this same excel in QV in QlikView

How to create this same excel in QV

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

		QA			SIT			Dev
Business	ID	Scount	Ann Cost	Ster Cost	Scount	Ann Cost	Ster Cost	Scount	Ann Cost	Ster Cost
Abc	1	100	18000	300	400	10000	10	400	21000	30
def	2	200	21000	500	700	31000	200	1000	61000	70
lmn	3	300	24000	700	1000	32000	390	1600	101000	110
son	4	400	27000	900	1300	43000	580	2200	141000	150
xyz	5	500	30000	1100	1600	54000	770	2800	181000	190
takl	6	600	33000	1300	1900	65000	960	3400	221000	230
mota	7	700	36000	1500	2200	76000	1150	4000	261000	270
raks	8	800	39000	1700	2500	87000	1340	4600	301000	310
tild	9	900	42000	1900	2800	98000	1530	5200	341000	350

Thanks for your help.

Re: How to create this same excel in QV

Anonymous — Tue, 26 Jul 2016 15:52:59 GMT

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

Re: How to create this same excel in QV

Anonymous — Tue, 26 Jul 2016 16:01:54 GMT

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

Re: How to create this same excel in QV

Anonymous — Tue, 26 Jul 2016 16:14:51 GMT

now how about the attached

Re: How to create this same excel in QV

Anil_Babu_Samineni — Tue, 26 Jul 2016 16:17:58 GMT

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.

Re: How to create this same excel in QV

Anil_Babu_Samineni — Tue, 26 Jul 2016 16:29:30 GMT

Can i know is this in Qlikview / Qlik sense

Re: How to create this same excel in QV

Anonymous — Tue, 26 Jul 2016 17:00:15 GMT

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

Re: How to create this same excel in QV

Anonymous — Tue, 26 Jul 2016 17:31:14 GMT

ankitd_modi

does my solution did not help you