Discussion Board for collaboration related to QlikView App Development.
I want to generate a table like this
Loco number is autogenerated field (through Rowno() i made it in backend)
Green highlighted columns will be given,rest all need to be filled accordingly.
Logic is :
The Yellow highlighted columns i.e. Loco Numbers must be filled by the [Total Units Recieved]/[Units/Loco] value.
For eg. if Total units received is 20 and Units/loco is 4 then till 5 locos 1,2,3,4,5 it should be filled.Likewise for all row values.
I tried by loop but i don't know where am i losing it.
Code i wrote :
Rowno() as Loco_No_1,
[Total Units Received],
[Total Units Received]/[Units/Loco] as Final_Units
(ooxml, embedded labels, table is Test_Units);
For i=1 to 50
[Total Units Received] as TestTab_UnitsReceived,
Final_Units as TestTab_Final_Units,
[Units/Loco] as TestTab_UnitsPerLoco,
if([Total Units Received]<=Final_Units,$(i),[Units/Loco]) as Values_Filled
Kindly help me on this.