Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

Cross table wanted

Hi Qlikers,

I have a small requirement let me explain. I have four variables two for product and two for supplier. My requirement of showing the data is in this way.

            Old           New       Growth
Product1500200025%
Supplier50004500-11.11%

But I have used to straight table without any dimension and I got the data in a single row.

point to be noted I dont have Product, Supplier Dimensions(assumption).I am attaching a sample qvw(Wanted Dimension sheet).

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

5 Replies
Highlighted
MVP
MVP

Create a Pivot Table

Calculated Dimension

=ValueList('Product','Supplier')

=ValueList('New','Old','Growth')

Expression

IF(ValueList('Product','Supplier') = 'Product' and ValueList('New','Old','Growth') = 'New', Num($(ProductNewSale),'##0') ,

IF(ValueList('Product','Supplier') = 'Product' and ValueList('New','Old','Growth') = 'Old', Num($(ProductOldSale),'##0') ,

IF(ValueList('Product','Supplier') = 'Product' and ValueList('New','Old','Growth') = 'Growth', Num(($(ProductNewSale) - $(ProductOldSale))/$(ProductNewSale),'#0.00%') ,

IF(ValueList('Product','Supplier') = 'Supplier' and ValueList('New','Old','Growth') = 'New', Num($(SupplierOldSale),'##0') ,

IF(ValueList('Product','Supplier') = 'Supplier' and ValueList('New','Old','Growth') = 'Old', Num($(SupplierNewSale),'##0') ,

IF(ValueList('Product','Supplier') = 'Supplier' and ValueList('New','Old','Growth') = 'Growth', Num(($(SupplierOldSale) - $(SupplierNewSale))/$(SupplierNewSale),'#0.00%')))))))

Check enclosed file...

Highlighted
Specialist III
Specialist III

Thanks Manish for your immediate response, what I want is actually this but can we avoid the two labels Dimension1 and Dimension2 so that it looks like a cross table.

Thanks

Kiran Kumar

Highlighted
MVP
MVP

Highlighted
Specialist III
Specialist III

Thanks alot, can you share or create a document which explains how valuelist or valueloop functions works.

Kiran Kumar