Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Jwillmann
New 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
Valued Contributor II

Re: Changing view without selecting first.

Try:

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

View solution in original post

7 Replies
anushree1
Valued Contributor II

Re: Changing view without selecting first.

Try:

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

View solution in original post

Jwillmann
New Contributor III

Re: Changing view without selecting first.

Thank you for your help Anushree1,

 

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

Highlighted
anushree1
Valued Contributor II

Re: Changing view without selecting first.

It should work what is the dimension you are using

Jwillmann
New Contributor III

Re: Changing view without selecting first.

The Dimension is Month,

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

Thought they are the important ones.

anushree1
Valued Contributor II

Re: Changing view without selecting first.

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
New Contributor III

Re: Changing view without selecting first.

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
Valued Contributor II

Re: Changing view without selecting first.

No worries at all..

Glad that its working:)