Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
asantos
Contributor III
Contributor III

How to ignore a dimension based filter in an expression

Hi,

Currently, I got an expression where I try to get the Unit Price, by Sum({<Totais = {'$(vTotalDisc)','N/A'}>}Revenue) / Sum({<Totais = {'$(vTotalDisc)','N/A'}>}Volume). This would give me an additional column with null values.

I've tried escaping the "filter" set through a button, stating DescontoSimples, OtherDiscounts, etc, but since DescontoSimples is selected, it doesn't allow Unit Price to consider Volume, whose first column's data is N/A 

Below is a visual simulation of the problem.

Imagem1.png

Appreciate your time put into trying to get this one right.

 

 

4 Replies
Vegar
MVP
MVP

Try this expression

Sum({<Totais = {'$(vTotalDisc)','N/A'}>}Revenue) / Sum({<Totais = {'$(vTotalDisc)','N/A'}>}TOTAL Volume)

asantos
Contributor III
Contributor III
Author

Thanks for responding, @Vegar !

It then gives me a Price much lower than it should and I guess it's because it considers everything in the volume field.

Kushal_Chawda

@asantos  try to exclude selection of DescontoSimples

Sum({<Totais = {'$(vTotalDisc)','N/A'}>}Revenue) / Sum({<DescontoSimples,Totais = {'$(vTotalDisc)','N/A'}>}Volume)

Vegar
MVP
MVP

Is the price lower than expected in the Totals row as well?

Maybe you could create a mockup data sample for us and a picture of your desired final output?