General charting questions

[Anonymous]

Greetings.

I have some general questions.

I have data similar to this..

Name            Branch             Sales

Chikfila          Johnstown        2.3

Chikfila          Frederick           6.7

Chikfila          Windhym           5.1

BK                 Johnstown         1.5

BK                 Frederick           1.6

McD              Johnstown          2.4

McD              Windhym             2.6   

1.  i'd like to have a stacked bar chart that displays always, regardless of filter selections, chikfila sales by branch, so Johnstown 2.3, Frederick 6.7, and Windhym 5.1, and then a sum of all the others, so Others 8.1.  However, if a user selects BK from the filter drop-down, i'd like the chikfila sales to stay the same, Johnstown 2.3, Frederick 6.7, and Windhym 5.1, and the Others stacked bar to switch to the sum of BK Johnstown and Frederick of 3.1 only.

so, based on what i'm describing, would my Chikfila expression be

sum({1}{$<Name={'Chikfila'}>} Sales)?

However, this doesn't break chikfila out by the branches... how do I get it to break out the individual branches as well?  would I aggr it by branch?  is this possible?

My others sum would be sum of sales not equal to Chikfila...what is that syntax??  sum({$<Name NOT EQUAL TO {'Chikfila'}>} Sales)?

2.  how can I ensure that regardless of other page filters/selections that these charts always display what is unique to this individual tab?

Thanks,

Maria

[sergio0592]

My others sum would be sum of sales not equal to Chikfila...what is that syntax??  sum({$<Name NOT EQUAL TO {'Chikfila'}>} Sales)?

Try with =sum({$<Name-={'Chikfila'}>} Sales)

[sunny_talwar]

May be like this?

Without selection

With selection

Created an island table in the script

Table:

LOAD * INLINE [

    Name, Branch, Sales

    Chikfila, Johnstown, 2.3

    Chikfila, Frederick, 6.7

    Chikfila, Windhym, 5.1

    BK, Johnstown, 1.5

    BK, Frederick, 1.6

    McD, Johnstown, 2.4

    McD, Windhym, 2.6

];

Dim1:

LOAD * Inline [

Dim1

1

2

];

And then the bar chart with following

Dimensions

=Pick(Dim1, Name, 'Other')

=Pick(Dim1, Branch, 'Other')

Expression

=Pick(Only({1}Dim1), Sum({<Name = {'Chikfila'}>} Sales), Sum({<Name -= {'Chikfila'}>} Sales))

[Anonymous]

I have the chart by month...that is my dimension...  then I have two expressions as the measures..  and then they are stacked on top of each other..  I neglected to mention that.  sorry.  the data looks more like this..

Table:

LOAD * INLINE [

    Name, Branch, Sales, MonthOfSales

    Chikfila, Johnstown, 2.3, 1/31/2016

    Chikfila, Frederick, 6.7, 1/31/2016

    Chikfila, Windhym, 5.1, 1/31/2016

    BK, Johnstown, 1.5, 1/31/2016

    BK, Frederick, 1.6, 1/31/2016

    McD, Johnstown, 2.4, 1/31/2016

    McD, Windhym, 2.6, 1/31/2016

Chikfila, Johnstown, 2.3, 2/28/2016

    Chikfila, Frederick, 6.2, 2/28/2016

    Chikfila, Windhym, 5.0,2/28/2016

    BK, Johnstown, 1.2,2/28/2016

    BK, Frederick, 1.1,2/28/2016

    McD, Johnstown, 2.0,2/28/2016

    McD, Windhym, 2.1,2/28/2016

];

here is what i'd like the chart to look like.. but I want the blue bar to have the branches listed...  right now I have it by name, but i'd really like to have it by branch..however, I don't know all of the branches individually.  I just know that I want to focus on the chikfila store.  then for the red, that's the others.  I want the sum of all the other restaurants...I don't care about the name of branch for the display.

[sunny_talwar]

Would you be able to share your app where you have setup the initial bar chart so that we don't have to duplicate the effort here

[Anonymous]

hi,

how do I share it?  just share the qvw file?  I'm using qliksense at work and qlikview at home.  trying to transition between the two is driving me cuckoo.  and I'm new to both.

[sunny_talwar]

You can share either or... Whatever is readily available

[Anonymous]

I tried to attach what i'm working on...  please excuse the work..it's very rough.  i'm in the beginning stages of this.

thanks,

maria 

[Anonymous]

I want to have century 21 new millennium on the bottom but sliced by branch.  then I want the sum of the others to be on the top...just one lump sum...I don't care what the company names are..

[sunny_talwar]

Are you talking about the pie chart?