No Expression for pivot expression

[iliaisyah]

if i use flat table, i can express the view with the expression

when i want to add more variable and use pivot, the expression cannot be read

the first table is ok with pivot

second the expression is Act_Yield01/Budget01 but the expression did not show

[jonathandienst · Accepted solution]

You probably need a Sum() around the Act_Yield01 field, and possibly also the budget. Use one  of these:

Sum(Act_Yield01) / Budget01
Sum(Act_Yield01) / Sum(Budget01)
Sum(Act_Yield01 / Budget01)

The correct option depends in your data model.

[agni_gold]

post your app.

[iliaisyah]

what is app?

[MindaugasBacius]

The Qlikview document *.qvw is called an application in short an app 🙂