Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Jwillmann
Contributor III
Contributor III

Changing view without selecting first.

Hello Community,

I have a table that looks like this:

customercompanysales
customer1Our Company2000
customer2Our Company3000
customer1Company24000
customer2Company25000
customer1Company36000
customer2Company37000

 

I want to make charts with the sales for our company without selecting it first.

thought about an if statement something like if([Company]=[Our Company],Sales but i am kinda stuck there.

Thanks for the Help in advance

 

Jwillmann

1 Solution

Accepted Solutions
anushree1
Specialist II
Specialist II

Try:

sum({<company={'Our Company'}>}Sales)

View solution in original post

7 Replies
anushree1
Specialist II
Specialist II

Try:

sum({<company={'Our Company'}>}Sales)

View solution in original post

Jwillmann
Contributor III
Contributor III
Author

Thank you for your help Anushree1,

 

sadly that does not work, my barchart is still showing the sales for all 3 companies.

anushree1
Specialist II
Specialist II

It should work what is the dimension you are using

Jwillmann
Contributor III
Contributor III
Author

The Dimension is Month,

sorry should have added that i have more fields then the mentioned.

Thought they are the important ones.

anushree1
Specialist II
Specialist II

Can you share the sample file 

I created a chart with Customer Dimension showing sales only for 'Our Company', please check for your reference.

It shows data only for our company in the chart

Jwillmann
Contributor III
Contributor III
Author

Thank you for your help,

and sorry for replying so late, i can confirm that this works in the demo file you sent.  I changed my datastructure to work around my issues.

anushree1
Specialist II
Specialist II

No worries at all..

Glad that its working:)