Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
musketeers
Creator
Creator

need help in straight table

Hi,

I need to create a straight table from following data:

ClientProd-1Prod-2Prod-3Prod-4
X1100200300400
X2101201301401
X3102202302402
X4103203303403
X5104204304404
X6105205305405
X7106206306406
X8107207307407
X9108208308408
X10109209309409

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:

DimensionExpression
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

7 Replies
Not applicable

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

Not applicable

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.

iktrayanov
Creator III
Creator III

Just use a pivot table and format it like this

musketeers
Creator
Creator
Author

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.

iktrayanov
Creator III
Creator III

Just use Product for your dimension and it should work.

Not applicable

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

udit_kumar_sana
Creator II
Creator II

Hi,

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

Thanks & Regards,

Udit