Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! i'm already applyed method from this guide: Recipe for an ABC Analysis
But now i need another approach:
in Recipe for an ABC Analysis we get results like "how much best 20% clients makes money for me". I need solve this in key "Who is this clients, who makes 80% money for me".
I make this table:
It counts accumulative percentage for clients, that sorted by decease of Delta. Formula:
RangeSum(Above(sum(Дельта)/sum(TOTAL Дельта),0,rowno()))
ABC - its measue with formula:
If(RangeSum(Above(sum(Дельта)/sum(TOTAL Дельта),0,rowno()))>0.95,'C',
If(RangeSum(Above(sum(Дельта)/sum(TOTAL Дельта),0,rowno()))>0.80,'B','A'))
Now, i want to select all 'A' clients in one click. That means i need calculate ABC as Dimension. And i have problem with it.
When im changing formula of ABC like this:
aggr(If(RangeSum(Above(sum(Дельта)/sum(TOTAL Дельта),0,rowno()))>0.95,'C',
If(RangeSum(Above(sum(Дельта)/sum(TOTAL Дельта),0,rowno()))>0.80,'B','A')),[Brand name])
And switch it type to Dimension, it brokes my accumulative percentage, end calculated incorectly:
What i must change in my formulas?
Privet, Vadim
Well, because this project we made for Qlik Sense Desktop, i find parial solution: use extension of Slider Variable, that controls client percentage in A group.
ABC dimension counts like in Recipe for an ABC Analysis
So i can adjust it for each selection, to include in Group A 80% of Delta)
Vadim, what do you mean about "we went full scale into mashup environment"? It possible to make in Qlik Sense Server?
Hey there,
Can you give us a sample of your data?
Did you tryed using Set Analysis in this case?
Regards,
MB
Hi, Evgeny.
I believe that's not possible in standard Qlik Sense application. We have same requirements and only recently, when we went full scale into mashup environment that kind of scenarios become possible for us.
It looks like this:
Recipe for that is to dynamically prepare formula for ABC calculated dimension on every change in selection. (In our case on every change in selected dimension, selected measure, and ABC border values too).
I've tried to do something like that with Qlik Sense extensions, but I believe that's is not possible yet.
Privet, Vadim
Well, because this project we made for Qlik Sense Desktop, i find parial solution: use extension of Slider Variable, that controls client percentage in A group.
ABC dimension counts like in Recipe for an ABC Analysis
So i can adjust it for each selection, to include in Group A 80% of Delta)
Vadim, what do you mean about "we went full scale into mashup environment"? It possible to make in Qlik Sense Server?
Hi,
Please try following expression. if you got your output reply us.
Aggr(If((Rank(Sum(Дельта),1)-1) / Count(distinct total BrandName)< 0.50, 'A',
If((Rank(Sum(Дельта),1)-1) / Count(distinct total BrandName)< 0.75, 'B', 'C')),BrandName)
Thanks,
Interesting. Probably that's the best approach available in standard Qlik Sense.
We, basically, are doing very similiar thing, only we calculate parameters for ABC dimension formula automatically, using Qlik Sense API.
Vadim, what do you mean about "we went full scale into mashup environment"? It possible to make in Qlik Sense Server?
Mashups can be deployed both in Qlik Sense Server and Desktop environment, AFAIK. But I've tried it only with Qlik Sense Server.
Sorry, that not works(
Can we speak in russian? Skype, may be?
I've sent a PM with skype account