topic Re: Multiple Dollar Expansion expression in Straight table not working in QlikView

Multiple Dollar Expansion expression in Straight table not working

Thu, 01 Aug 2013 06:45:55 GMT

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

Re: Multiple Dollar Expansion expression in Straight table not working

Kushal_Chawda — Thu, 01 Aug 2013 06:58:11 GMT

Hi,

There is workaround for this.

Find the attached application

Re: Multiple Dollar Expansion expression in Straight table not working

Thu, 01 Aug 2013 07:24:15 GMT

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

Re: Multiple Dollar Expansion expression in Straight table not working

Kushal_Chawda — Thu, 01 Aug 2013 08:47:32 GMT

See the attached application

Re: Multiple Dollar Expansion expression in Straight table not working

Thu, 01 Aug 2013 09:05:11 GMT

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.

Re: Multiple Dollar Expansion expression in Straight table not working

Fri, 02 Aug 2013 06:03:21 GMT

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

Re: Multiple Dollar Expansion expression in Straight table not working

Kushal_Chawda — Fri, 02 Aug 2013 06:18:21 GMT

can you share what exactly have you done

Re: Multiple Dollar Expansion expression in Straight table not working

Tue, 06 Aug 2013 07:16:14 GMT

Attaching my workaround.

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