rows to coloum

[Anonymous]

Hi,

I have  a file called kpicategory with childcare, control, efficinecy .. (5 values) i need this 5 values as column values now..

I want to take this in straight table..  i know we can rearrage the column in pivot but i need this in pivot for other calculation purpose i need in straight table

Now:

KPI_Category
Child Care
Control
Disease Prev
Efficiency
Mortality

I need it as :

KPICategory

child care   control disease prev efficinet mortalily .

I want to take this in straight table..  i know we can rearrage the column in pivot but i need this in pivot for other calculation purpose i need in straight table

[sunny_talwar]

You can use The Generic Load or For Loop to do this. Can you share the Excel files to show how this can be done?

[sunny_talwar]

Your QlikView description of what you want is different then what you have in your post above. What exactly do you want?

[kaushiknsolanki]

Hi,

Simply try this expression

Sum(Numerator/Denominator)

Regards,

Kaushik Solanki

[Anonymous]

HI sunny

Thanks for the response.

in the workbook i sent there are two text objects.. i can be happy either of the solution is achieved for me..

[Anonymous]

hi,

it will sum up the values i dont want sumed up valus

[kaushiknsolanki]

Do you want to show the values in dimension?

Regards,

Kaushik Solanki

[Anonymous]

I need them in expression only

or

i need the kpi category to be shown in column wise ....

atpresent they are shwing in row wise

i need this in straight table only

[kaushiknsolanki]

Can you give us some sample, the kind of visualization you need.

Regards,

Kaushik Solanki

[Anonymous]

HI this is the UI need... i can take the childcare, trend etc.. in pivot tabel but the problem lies in the calculation..

i.e 5/5, 0/2 etc.. these are calculated based on the logic..count ( numerator/denominater ) >= target
i.e if count of nume/denom is 9.9 and target value for that area is 9.5 - so our achieved kpi is 1..

buti need to calculate like this how many are greater than target

Hope you understand it, if not let me know please..

i need to sort this out