Discussion Board for collaboration on QlikView Scripting.
potentially easy solution, need to know how to calculate same value already in load script and by that creating a field.
Example: (Now I need the possibility to calculate the purple header during the load script)
Field Header: Order | Product | Customer | Qty. Products on Order
Field Content: A small John 2
A big John 2
count(order) as Qty.Products on order
group by customer,product,order;
hope it helps!
You are asking for table header for this you can use the variable or Calculated labels in the chart. Please share the data if have sample of this.
Qty * Product //As label
Really that easy ? Now I feel shamed
Will try it was wondering because what I will have multiple different order and customers.
Will try ....
In load script if you use you have to group by by all fields available
Count(Order) as OrderCount,
Qty * Product as QtyProducts
For chart headers you have do like
Red part I have already in my source
Field Content: A small John 3
A big John 3
A small John 3
B small Paul 1
TEST: LOAD A, count(A) as QTY_A RESIDENT TABLE_XYZ group by A;
This doesn't work:
TEST: LOAD A, count(A) as QTY_A, if(wildmatch(PRODUCT,'small'),count(A),0) as QTY_small, if(wildmatch(PRODUCT,'big'),count(A),0) as QTY_big RESIDENT TABLE_XYZ group by A;
A 3 2 1
B 1 1 0