Opposite of transpose

[#1]

Hi there

I have a table shown below (which I created in a Table Box).

I want to show the same information in qlikview as follows (using a resident LOAD).

Could somebody help me with the transformation?

The reason why I want it like this is to create columns which show the percentage change in Cash amounts from one period to the next and then highlight those that exceed a certain percentage; using a straight table.

[sunny_talwar]

I would suggest creating a Pivot Table instead of making changes to your script.

Look here: The Generic Load

[pooja_sn]

Add a Chart -> Pivot table.
Select 2 dimesions - 1. Emp_No

                                  2. Add a calculated dimension = 'P' &Period

Use after/before while calculating expression value accordingly to add comparisons.

Dimensions can be dragged and placed horizontally.

[#4]

Ok, I've created the pivot but I've never used the before/after functions.  What do I do next from here to get the % change between periods.

[#5]

ok, please ignore the above, I managed to get it.  Now I want to only show percentages > 50% in the pivot table.   How do I do this?

Below is just a screenshot of what I have so far.

[pooja_sn]

Use below expression:

(sum(E_CashComp) - Before(sum(E_CashComp)))/Before(sum(E_CashComp))

To display the calculated values in percentage - Goto Properties -> Number tab -> Select expression and check 'Show in Percentage %'

[sunny_talwar]

Would you be able to share a sample of what you are seeing and what you intend to see?

[#8]

The pivot table currently shows results for ALL employees, see below:

But I only what to see just the employees where the values exceed 50% such as employee number 00012048 where the increase from August to September was 67%.

[#9]

Thanks Pooja

I managed to get this to work but I still cant figure out how to only show records (i.e. employees) where values are 50% and above. At the moment all records show, which I don't need.   See previous post.

[#10]

Hi Hetal,

I think you can write using if loop like below. And you can omit the values which are null by using the property supress null values.

if(% value >50 , fine,null)

Thanks,
Sreeman.