Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
florian890
Contributor III
Contributor III

Sumifs challenge

Good day, all!

based on below table I would like to show share of 1 customer on total volume/quater/year.

I know I need to take a scripting course but till then eager to progress still... Thanks for your kind support,

Florian

PS: I know there have been some good discussions around that topic already but I am not sure what and where to do with them, sincere apologies for duplications!

PPS: And by renewing the discussion someone might actually be able to earn some credits to progress in the system 🙂 Win-Win?

Screen Shot 2017-07-18 at 09.16.27.png

1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

Hello Florian,

it make sense to compare quarters, but in two years?

So create a table, Customer, Year and Quarter as dimension

Create expression 1: sum(Revenue)

Create expression 2: sum(Revenue) / sum(total <Quarter, Year> Revenue)

Regards

View solution in original post

7 Replies
Not applicable

This is possible to do just in the charts (you could pre calculate it in the load script, but you lose some flexibility in terms of the analysis you can subsequently do in the UI, and I would only recommend that approach for very specific performance tuning scenarios).

Take a look at this blog post for an example of the TOTAL qualifier - it should point you in the right direction:

What does the TOTAL qualifier do?

martinpohl
Partner - Master
Partner - Master

Hello Florian,

each customer have one value, so what is the result you are looking for?

Regards

florian890
Contributor III
Contributor III
Author

Hi Martin,

good question: I want to compare Q1 2016 & Q1 2017 in total market revenue AND the share of "my" of the total revenue.

In other words Quarter-growth comparison for total market and my share of that.

Does that make sense/explain?

Thanks for looking into this,

Florian

martinpohl
Partner - Master
Partner - Master

Hello Florian,

it make sense to compare quarters, but in two years?

So create a table, Customer, Year and Quarter as dimension

Create expression 1: sum(Revenue)

Create expression 2: sum(Revenue) / sum(total <Quarter, Year> Revenue)

Regards

martinpohl
Partner - Master
Partner - Master

have a look to our coaching example

florian890
Contributor III
Contributor III
Author

Took me some time but got it sorted, thanks for your patience and help!!!

florian890
Contributor III
Contributor III
Author

One more question, and I hate it myself already:

How do I import the qvf file? Working via internet on QS...