topic Re: General charting questions in QlikView

General charting questions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: General charting questions

sergio0592 — Sun, 26 Mar 2017 21:24:37 GMT

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)

Re: General charting questions

sunny_talwar — Sun, 26 Mar 2017 23:02:31 GMT

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

];

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))

Re: General charting questions

Anonymous — Mon, 27 Mar 2017 00:28:27 GMT

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.

Re: General charting questions

sunny_talwar — Mon, 27 Mar 2017 09:19:31 GMT

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

Re: General charting questions

Anonymous — Wed, 29 Mar 2017 14:56:13 GMT

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.

Re: General charting questions

sunny_talwar — Wed, 29 Mar 2017 14:57:22 GMT

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

Re: General charting questions

Anonymous — Wed, 29 Mar 2017 23:59:02 GMT

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

Re: General charting questions

Anonymous — Thu, 30 Mar 2017 00:11:21 GMT

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..

Re: General charting questions

sunny_talwar — Thu, 30 Mar 2017 01:33:16 GMT

Are you talking about the pie chart?

Re: General charting questions

Anonymous — Thu, 30 Mar 2017 12:59:48 GMT

no..the bar charts. I'd like every bar chart to have the branches of century 21 new millennium sliced out on the bottom blue, and then for the red bar, I'd just like a lump sum of the others...I don't care about the companies and/or the branches. I'm trying to show how much c21nm represents out of all listings...but I want to show how much each branch of c21nm represents out of all the listings.

Re: General charting questions

sunny_talwar — Thu, 30 Mar 2017 14:03:34 GMT

Something like this?

Re: General charting questions

Anonymous — Thu, 30 Mar 2017 14:19:11 GMT

yes. what are the blue, yellow, green, and red bars? what is the expression you're using for that?

Re: General charting questions

sunny_talwar — Thu, 30 Mar 2017 14:37:45 GMT

Purples are everything else and Blue, yellow, green and red bars are the branchs for C21.... I have attached the sample app here: Re: General charting questions

Expression is this

=Pick(Dim,

Sum({1<ListOfficeName={'Century 21 New Millennium'}, ListDateFlag={1}>} OriginalListPrice),

Sum({1<ListOfficeName-={'Century 21 New Millennium'}, ListDateFlag={1}>} OriginalListPrice))

Dimensions

MonthYear

=Pick(Dim, ListOfficeNameBranch)

Where Dim is created in the script like this

Dim:

LOAD * Inline [

Dim

];

Re: General charting questions

Anonymous — Tue, 18 Apr 2017 00:17:36 GMT

thank you!