Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I need help on develop a table as below.
But this table cannot be build using Pivot or Straight Table or even Table Box.
Does anyone know how to develop this as i know the first column should be the words that we can key into field, is not a dimension that we can pull from database.
Below are the only result that i can get. But i need the left column name and i have more than 10 criteria to compare.
It seems nobody know how to solve? or do we have relevant post regarding this topic?
Hello,
for the dimension you can use a valuelist:
valuelist('Actual Sales Vs Target Sales','TotalRevenue','Gross Margin')
and in the part of expression the first expresion for Target Sales should be something like this:
pick(match(valuelist('Actual Sales Vs Target Sales','TotalRevenue','Gross Margin'),'Actual Sales Vs Target Sales','TotalRevenue','Gross Margin'), <Formula of Actual Sales Vs Target Sales >, <Formula of TotalRevenue>, <Formula of Groos Margin>)
hope this helps!!
Regards