topic where is File Wizard : Transform? in QlikView

where is File Wizard : Transform?

Fri, 26 Feb 2016 12:55:42 GMT

HI,

Can anyone let me know where I can see File Wizard: Transform

Thanks.

Re: where is File Wizard : Transform?

sunny_talwar — Fri, 26 Feb 2016 12:58:29 GMT

Step 1 and 2

Step 3

Re: where is File Wizard : Transform?

tresB — Fri, 26 Feb 2016 12:59:23 GMT

Script editor->Table Files, select a file (may be an excel) ->OK->Next... it's there

Re: where is File Wizard : Transform?

Fri, 26 Feb 2016 13:03:22 GMT

Thanks. got it. that is for any excel file. if I want to transpose any straight or pivot table rows to columns or columns to rows how do I need to do that?

please suggest me

Re: where is File Wizard : Transform?

sunny_talwar — Fri, 26 Feb 2016 13:07:25 GMT

For pivot table to a regular table conversion I would use CrossTable which you can get to by clicking next on this screen. and for transposing stuff you need to click on 'Enable Transformation Step' and then it you will see 5-6 options up top. One of them would be rotate you can use that to transpose or left or right lanes. Play around with it to see what it is doing.

Re: where is File Wizard : Transform?

Fri, 26 Feb 2016 13:11:58 GMT

Thanks. so, do I need to first right click on straight or pivot table to get b this screen? sorry I am not sure

Re: where is File Wizard : Transform?

sunny_talwar — Fri, 26 Feb 2016 13:15:04 GMT

Are you trying to visualize QlikView's object in a different orientation?

Try this for straight table:

For pivot table you can drag the dimensions to pivot stuff.

What I mentioned earlier was for loading the data. That cannot be used for QlikView's front end objects.

Re: where is File Wizard : Transform?

Fri, 26 Feb 2016 13:24:46 GMT

perfect Thanks. is there any way that I can put one column as horizontal and another one to vertical

I need 8 columns to horizontal and 1 column to display vertical

would it be possible?

Re: where is File Wizard : Transform?

sunny_talwar — Fri, 26 Feb 2016 13:32:02 GMT

‌That requirement sounds more like a Pivot table kind of table

Re: where is File Wizard : Transform?

Fri, 26 Feb 2016 13:48:55 GMT

yes with pivot table I can able to get 8 columns ok. but the 9 and 10th columns are not showing what my user want.

actually I need like below. I can not able to get constantvaliue and Difference columns

Difference column values are Total - constantvalue

data	19/02/2016	22/02/2016	23/02/2016	24/02/2016	25/02/2016	Total	constant value	Difference
we	4	3.00	5	3	1	16	32	-16
er	1	4	3	2	0	10	32	-22
tr	1	4	2	2	0	9	32	-23
%	100%	100%	67%	100%		90%	32
erq	3	8	3	0	8	22	32	-10
sdf	4	8	6	2	11	31	32	-1
adc	2	10	0	11	5	28	32	-4
cds	7	9	13	8	9	46	32	14

can you help me how to add constantvaliue and Difference columns