topic Re: need help in straight table in QlikView

need help in straight table

musketeers — Mon, 29 Dec 2014 14:45:21 GMT

Hi,

I need to create a straight table from following data:

Client	Prod-1	Prod-2	Prod-3	Prod-4
X1	100	200	300	400
X2	101	201	301	401
X3	102	202	302	402
X4	103	203	303	403
X5	104	204	304	404
X6	105	205	305	405
X7	106	206	306	406
X8	107	207	307	407
X9	108	208	308	408
X10	109	209	309	409

I have to create a list box for Client names so that user can select clients from that filter. This I have created.

Now in straight table I need to display following info:

Dimension	Expression
Total of 4 Products	<sum of all values of all 4 products of selected client>
Total of 3 Products	<sum of all values of all 3 products of selected client>
Total of 2 Products	<sum of all values of all 2 products of selected client>
Total of 1 Products	<sum of all values of all 1 products of selected client>

Since in my data table I have more than 4 products but I need to do this operation on only given 4 products.

I am trying to do but I am getting straight table in wrong format.

Please help me in doing this.

Thanks

Re: need help in straight table

Mon, 29 Dec 2014 17:15:40 GMT

Hi,

Can you pls explain some more..

Little bit confusion...

As per your data i thought client - Dimension,

Sum([Prod-1])+Sum([Prod-2])+Sum([Prod-3])+Sum([Prod-4]) -- Expr

I hope check with this..

Sub2u

Re: need help in straight table

Mon, 29 Dec 2014 21:05:25 GMT

Unless there is a reason to do the aggregation in the chart, I prefer to do it in the load script.

Attached is an example using the script and the horizontal feature of the straight table.

Re: need help in straight table

iktrayanov — Mon, 29 Dec 2014 22:29:11 GMT

Just use a pivot table and format it like this

Re: need help in straight table

musketeers — Tue, 30 Dec 2014 11:08:09 GMT

Hi,

Actually I have created cross table from my data table, where my fields in cross table are Client, Product, Value.

Now I was using if (match(Product, 'Prod-1'), 'Total of 1 Prod') type of expressions in dimension and SUM(Value) in expression.

But this is not working.

Actually I do not want to hardcode these things in Load script. So I am doing all these things in dashboard page only.

Is there any way as what I am doing in straight table is not giving correct output.

Re: need help in straight table

iktrayanov — Tue, 30 Dec 2014 15:42:08 GMT

Just use Product for your dimension and it should work.

Re: need help in straight table

Wed, 31 Dec 2014 17:34:14 GMT

Ok, the customer is always right

If you want to do it in the expression, try this one, it uses your data from the crosstable and then creates a chart that accumulates the first 4 values

Re: need help in straight table

udit_kumar_sana — Thu, 01 Jan 2015 15:23:25 GMT

Hi,

Pls find the attached file for your issue done at expression level.

Thanks & Regards,

Udit