Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Pivot Table with two dimensions and formulas for each case

I cannot expand the Formulas in a pivot table.

I made a Load Inline to create this two dimensions, here is the code:

'Tipo Valor', 'Medida', 'Fórmula Financeiro'
'Receita', 'Descontos Obtidos', "vReceitas Descontos Obtidos"
'Receita', 'Juros Auferidos', 'vReceitasJurosAuferidos'
'Receita', 'Outras Receitas Financeiras', 'vReceitasOutrasReceitasFinanceiras'
'Receita', 'Ganhos Oper. Renda Variável', 'vReceitasRendaVariavel'
'Receita', 'Variações Monetárias Ativas' , 'vReceitasVariacoesMonetarias'
'Receita', 'Variações Cambiais', 'vReceitasVariacoesCambiais'
'Receita', 'Outras Receitas Operacionais', 'vReceitasOutrasReceitasOperacionais'
'Despesa', 'Bancárias'
'Despesa', 'Monetárias Passivas'
'Despesa', 'Arredondamento Mercantil'
'Despesa', 'Juros Pagos'
'Despesa', 'Bancárias Exportação'
'Despesa', 'Variações Cambiais'
'Despesa', 'Perda Renda Variável'

Here is what happens:


 I need to expand the formulas, thought it was just put $([Fórmula Financeiro]) in measures but it doesn't work.


With ValueList i can make this work but than if you select it doesn't select in the right way than for me it doesn't work, i need in this way because than the user can select and then it will filter.


Obs: this variables contains the formulas

Example: vReceitasDescontosObtidos contains Sum([Receitas Descontos Obtidos]/1000)

Labels (3)
1 Reply

Make sure that all variables measure fields are associated to any fact table? If so, can you post with example to verify?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)