Multiple Dollar Expansion expression in Straight table not working

[#1]

My requirement is to load a formula column as dollar expansion expression into qlikview and calculate at runtime.

This works if formula is same across all rows, but doesn't work if formula is different for each row.

e.g.

If I load following data into QlikView and create a straiht table with FormulaName as Dimension and =$(=FormulaExp) as Expression, it works because formula 1+1 is same in all rows.

Formula:

LOAD * INLINE [

    FormulaName, FormulaExp

    Formula1,1+1

          Formula2,1+1

];

But If I load followin data into QlikView and do the same in straight table it doesn't work

Formula2:

LOAD * INLINE [

    FormulaName2, FormulaExp2

    Formula1,1+1

          Formula2,2+2

];

Attaching QVW illustrating this issue.

Appreciate if someone can help me fix this issue or suggest any workaround

[Kushal_Chawda]

Hi,

There is workaround for this.

Find the attached application

[#3]

Thanks for the reply

Yes this works but for arithmatic formula or formula which is not dependent on other tables.

My intention for this approach was to load formulas that count,sum other tables loaded in same QVW.

Is there anyway we can do that?

e.g. my formulas will be variations of following formula

(Count(TBL1.COLUMN1)+Count(TBL2.COLUMN1) - Count(TBL3.COLUMN1))/(Count(TBL1.COLUMN1)+Count(TBL2.COLUMN1))

where TBLs are resident tables in same QVW

[Kushal_Chawda]

See the attached application

[#5]

This is exactly my problem. If you clear selection on Dim in your attachment then chart doesn't work.

It works only for one formula at a time.

I want it to work for mutiple formulas i.e. one formula per row.

[#6]

I have solved this by creating each row in pivot as seperate pivot and stacking them one below another and switching off header/caption for subsequent rows.

This is maintenanace disaster but I can not think of any simpler workaround

[Kushal_Chawda]

can you share what exactly have you done

[#8]

Attaching my workaround.

I simply created separate pivot for each row. This is very crude way but don't see any other option.