Distribute computed expression value into next columns of expressions on Pivot or Straight table!

Mon, 15 Dec 2014 10:39:54 GMT

Hi Qlikers,

I have a scenario where once a value is calculated on pivot or straight table, then the generated computed value has to be distributed randomly across next few columns.

e.g.: Year = 2001 .. Sum of Sales = 2000 (i.e. expression Column 1) .. then next 3-4 expression columns will have 2000 divided randomly across them.

So Expression Column 2 = 1000, Expression Column 3 = 400 & Expression Column 4 = 600.

Year = 2002 .. Sum of Sales = 1000 (i.e. expression Column 1) .. then next 3-4 expression columns will have 1000 divided randomly across them.

So Expression Column 2 = 600, Expression Column 3 = 300 & Expression Column 4 = 100.

Example given below on what I need.

Year	Expression 1 (Sum of Sales)	Expression 2	Expression 3	Expression 4
2001	1000	600	400	1000
2002	1200	100	700	400
2003	1100	1000	50	50
2004	2000	1200	600	400

If any such expression is possible, then do share and it will be of great help.

Thank you!

Regards,

Shri

topic Distribute computed expression value into next columns of expressions on Pivot or Straight table! in QlikView

Distribute computed expression value into next columns of expressions on Pivot or Straight table!