Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
what is app?
The Qlikview document *.qvw is called an application in short an app 🙂