Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

where is File Wizard : Transform?

HI,

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

Thanks.

9 Replies

Re: where is File Wizard : Transform?

Step 1 and 2

Capture.PNG

Step 3

Capture.PNG

MVP
MVP

Re: where is File Wizard : Transform?

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

Not applicable

Re: where is File Wizard : Transform?

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?

For pivot table to a regular table conversion Capture.PNGI 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.

Not applicable

Re: where is File Wizard : Transform?

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

Highlighted

Re: where is File Wizard : Transform?

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

Try this for straight table:

Capture.PNG

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.

Not applicable

Re: where is File Wizard : Transform?

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?

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

Not applicable

Re: where is File Wizard : Transform?

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

   

   

data19/02/201622/02/201623/02/201624/02/201625/02/2016Totalconstant valueDifference
we43.005311632-16
er143201032-22
tr14220932-23
%100%100%67%100% 90%32
erq383082232-10
sdf4862113132-1
adc21001152832-4
cds791389463214

can you help me how to add constantvaliue and Difference columns