topic Re: rows to coloum in QlikView

rows to coloum

Anonymous — Thu, 23 Feb 2017 18:54:57 GMT

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

Re: rows to coloum

sunny_talwar — Thu, 23 Feb 2017 18:56:57 GMT

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?

Re: rows to coloum

sunny_talwar — Thu, 23 Feb 2017 18:58:30 GMT

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

Re: rows to coloum

kaushiknsolanki — Thu, 23 Feb 2017 19:01:24 GMT

Hi,

Simply try this expression

Sum(Numerator/Denominator)

Regards,

Kaushik Solanki

Re: rows to coloum

Anonymous — Thu, 23 Feb 2017 19:03:01 GMT

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..

Re: rows to coloum

Anonymous — Thu, 23 Feb 2017 19:17:46 GMT

hi,

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

Re: rows to coloum

kaushiknsolanki — Thu, 23 Feb 2017 19:25:02 GMT

Do you want to show the values in dimension?

Regards,

Kaushik Solanki

Re: rows to coloum

Anonymous — Thu, 23 Feb 2017 19:30:49 GMT

I need them in expression only

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

Re: rows to coloum

kaushiknsolanki — Thu, 23 Feb 2017 19:34:08 GMT

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

Regards,

Kaushik Solanki

Re: rows to coloum

Anonymous — Thu, 23 Feb 2017 19:41:06 GMT

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

Re: rows to coloum

Anonymous — Thu, 23 Feb 2017 19:41:21 GMT

please see my below response

Re: rows to coloum

Anonymous — Thu, 23 Feb 2017 19:50:59 GMT

any help?

Re: rows to coloum

kaushiknsolanki — Thu, 23 Feb 2017 19:52:25 GMT

Check this.

Regards,

Kaushik Solanki

Re: rows to coloum

Anonymous — Thu, 23 Feb 2017 19:56:43 GMT

thanks but i dont need the sum(num / deno) because it is taking the total sum for these numerator n denominator i only need count of num & demo whose values is greater than target

could you please find this?

Re: rows to coloum

kaushiknsolanki — Thu, 23 Feb 2017 20:02:20 GMT

Hi,

You can use this expression.

If(NUMDEN > Target,Count(KPIID))

Regards,

Kaushik Solanki

Re: rows to coloum

Anonymous — Thu, 23 Feb 2017 20:05:13 GMT

not exaclty the solution but i found a way

thnx

Re: rows to coloum

kaushiknsolanki — Thu, 23 Feb 2017 20:07:40 GMT

Great!

Please share what you did so that other community members who face same problem, can get help from what you found.

Regards,

Kaushik Solanki