Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
GuilhermeSchneider
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:

Valores_Financeiro:
LOAD * INLINE [
'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:

8b350d88ee404a6abb4002547ffad544.png

 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
Anil_Babu_Samineni

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)