Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Column to Row in qlikview

Hi , I got a requirement that i have shuffle column as row.  below is the requirement

StockitemItemtypeSaleInStock
Store1I1Product111
Store1I2Product201
Store2I1Product100
Store2I3Product234

AS

ItemItem TypeStockStore1Store2
I1
Product1
Sale10
Product2InStock10
I2
Product1
Sale03
Product2InStock14

I will look forward to appreciate your answer

1 Solution

Accepted Solutions
Not applicable

Re: Column to Row in qlikview

Yes Adam, I have already done with the requirement but forgot to close the thread. Thank you

5 Replies
adamdavi3s
Honored Contributor

Re: Column to Row in qlikview

Can you not simply deploy as a pivot table in the front end?

Not applicable

Re: Column to Row in qlikview

Please try this

tab1:

CrossTable(salesinstack, value, 3)

  LOAD Stock,

    Item,

    itemtype,

    Sale,

    instock

FROM

(ooxml, embedded labels, table is Sheet1);

Tab2:

generic Load Item,

Stock,value Resident tab1;

beck_bakytbek
Valued Contributor III

Re: Column to Row in qlikview

or you can use crosstable

beck

Not applicable

Re: Column to Row in qlikview

Yes Adam, I have already done with the requirement but forgot to close the thread. Thank you

Not applicable

Re: Column to Row in qlikview

pivot table :dimentions are item,itemtype,salesinstack,store1,store2

                 ExpressionSmiley Frustratedum(item)


Item

itemtype salesinstack store1 store2 Sum(Item)
11product1instock1022
Sale1022
12product2instock0-12
1-12
Sale0-12
1-12
13product2instock-313
413
Sale-313
413

itemtype store1 store2 Item salesinstack
product11011instock
product11011Sale
product2012instock
product2012Sale
product2112instock
product2112Sale
product2313instock
product2313Sale
product2413instock
product2413Sale

Please try this

under transformation wizard select crosstable ,set qualifier field is 3,Attribute field is salesinstack and Data field is Value.

tab1:

CrossTable(salesinstack, value, 3)

  LOAD Stock,

    Item,

    itemtype,

    Sale,

    instock

FROM

(ooxml, embedded labels, table is Sheet1);

Tab2:

generic Load Item,

Stock,value Resident tab1;

Community Browser