Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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.

 

 

Labels (1)
4 Replies
Vegar
MVP
MVP

Try this expression

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
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? 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes