Qlik Community

Ask a Question

App Development

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

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
asantos
Contributor III
Contributor III

Ignoring specific filter not working on a pivot table

Hi!

The challenge is to have it sum Volume even though its SelectionType column is different. Here's a representation of the table as the it is:

SelectionTypeDescriptionRevenueVolUnit Price
NAGross Unit Price100.000090.00010.00
SimpleDiscUnit Price90.000'Not showing''Therefore, no unit price'
NAVol 90.000 

 

There's a variable governing SelectionType through button and its name is vSelection.

The first part (green) gives me the Revenue, but when trying to get the Volume sum, it gives me null.

I've tried the second portion below in blue, ignoring SelectionType filter but it doesn't seem to work:

Sum({<SelectionType= {'$(vSelection)','NA'}>}[Revenue]) / Sum({1<SelectionType= p(SelectionType)>}Vol)

Thank you!

Labels (3)
4 Replies
sunny_talwar

You are trying to ignore selection in SelectionType field or do you want to allow it for Vol?

asantos
Contributor III
Contributor III
Author

Hi, @sunny_talwar !

I need Unit Price whose SelectionType is SimplesDisc to consider the Vol, despite its SelectionType is NA.

I thought that having Vol ignore SelectionType would solve it...

sunny_talwar

May be this?

Sum(TOTAL {1<SelectionType = {'SimplesDisc'}>} Vol)
asantos
Contributor III
Contributor III
Author

It doesn't give me a null anymore! 🙂

I believe it's getting everything now and the Unit Price is much lower that it should be. How would I now go about including a filter, considering that there is TOTAL there.

Thank you!