Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
KPage
Contributor III
Contributor III

Only want to show data from one "Source" filter

Hi,

I only want to show data from the "Warehouse" source. However, when I apply this formula 

if (Source <> 'Warehouse',0,[CW Sales])

I am not getting the correct answer. I do not want to include "Online" sales on this page. I think this has something to do with the "0" in the formula. Please see the attached image.

I also do not want to have to select the "Warehouse" filter.

 

Thank you

Labels (2)
5 Replies
Clement15
Partner - Specialist
Partner - Specialist

Hello,

have you tried this ?
sum({<Source={'Warehouse'}>}[CW Sales])

KPage
Contributor III
Contributor III
Author

I am receiving an error. My "CW Sales" are not showing as a "measure" in ther formula. (It is not showing as purple)

KPage_0-1708613283543.png

 

Clement15
Partner - Specialist
Partner - Specialist

Your measure must be a master measure, is it possible to create a new identical one by adding only {<Source={'Warehouse'}>} in it ?

KPage
Contributor III
Contributor III
Author

I do have CW Sales as a master measure. This is the expression-

Sum({<Date={ '$(=MaxWeek)' }>} [Dollar Sales])

 

How would I incorporate only Warehouse sales into this?

Clement15
Partner - Specialist
Partner - Specialist

Try it out with this :
Sum({<Date={ '$(=MaxWeek)' },Source={'Warehouse'}>} [Dollar Sales])