Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

omarbensalem
Esteemed Contributor

Use the Box-Plot for time Analysis; Help required.

Hi all ( mto‌ , stalwar1‌ ),

I've never used the Box Plot chart and was wondering if anyone could help me with it please

In fact, what my client wants is Time Analysis to know how much time his clients would take to do their first publication / candidature / service since the creation of their account.

To do such a thing:

I created the Nb_Of_Days to do each thing in the script (publication / candidature / service)

Then I used for each:

1) a bar chart (classification of 10 slots)

2) an Histogramme with 10 Bars (to have a detailed view by day in each selection)

Capture.PNG

Now, the question is :  I was wondering if this was possible to include in a Box Plot Chart (all the 3 axis)

sthing like this (excuse the horrible "art" of mine )

Capture.PNG

Thank u very much for ur expected help

9 Replies
ogautier62
Valued Contributor II

Re: Use the Box-Plot for time Analysis; Help required.

hi,

but why not a stacked bar ?

in dimension :

publication/candidature/service

ceil(nb_of-days/10)*10

in expression :

count()

boxplot is more usefull for fractile

regards

omarbensalem
Esteemed Contributor

Re: Use the Box-Plot for time Analysis; Help required.

Thank u for ur answer Olivier.

I don't have any dimension that regroups publication/candidature/service

nor have I one nb_of_days field

In fact, I have date_creation, date_publication, date_candidature, date_service

and based on that I calculate nb_of_Days_publication , nb_of_Days_Candidature, nb_of_Days_Tampon


That said, I can't figure out a way to use ur method with a stacked bar

As I said; what I was doing is sthing like this:

in the bar chart  : (for publication)

as dimension:

if(Nb_deJours_Publication>=0 and Nb_deJours_Publication<10, '< 10 jours',

if(Nb_deJours_Publication>=10 and Nb_deJours_Publication<20, '< 20 jours',

if(Nb_deJours_Publication>=20 and Nb_deJours_Publication<30, '< 30 jours',

if(Nb_deJours_Publication>=30 and Nb_deJours_Publication<40, '< 40 jours',

if(Nb_deJours_Publication>=40 and Nb_deJours_Publication<50, '< 50 jours',

if(Nb_deJours_Publication>=50 and Nb_deJours_Publication<60, '< 60 jours',

if(Nb_deJours_Publication>=60 and Nb_deJours_Publication<70, '< 70 jours',

if(Nb_deJours_Publication>=70 and Nb_deJours_Publication<80, '< 80 jours',

if(Nb_deJours_Publication>=80 and Nb_deJours_Publication<90, '< 90 jours',

if(Nb_deJours_Publication>=90 and Nb_deJours_Publication<100,'< 100 jours',

if(Nb_deJours_Publication>=100 , '> 100 jours')))))))))))

as a measure:

count(ID_Compte)

to have this:

Capture.PNG

and an histogramme as follow :

dimension:

Nb_deJours_Publication


to have this:

Capture.PNG


This process is then repeated for the candidature and service:

Capture.PNG



Which means, that I have to include the COUNT(ID) as a measure to build my time analysis around and find a way to regroup all  of the axis in one chart..


Ps: the BoxPlot was the demand of the client; far from being mine

ogautier62
Valued Contributor II

Re: Use the Box-Plot for time Analysis; Help required.

so you can use synthtic dimension with valuelist()

in dimension :

valuelist('publication','candidature','service')

in expression :

if(valuelist('publication','candidature','service') = 'publication',

      count(nb_jour_pub),

           if(valuelist('publication','candidature','service') = 'candidature',

etc

problem is with nb_of_days/10 because of three different field

maybe here too a synthetic dimension with valueloop(1,10)

and in expression : if(ceil or floor(nb_of_days) /10 = valueloop(1,10) then count()

I look for boxplot,

omarbensalem
Esteemed Contributor

Re: Use the Box-Plot for time Analysis; Help required.

and even though, if we find a way to include all nb_of_days, if I'd add as a second expression count(ID), would it return accurate results?

Besides, with ValueList, the chart won't be dynamic to selections anymore and thus, we could not see its interaction with the rest of the charts/data.

Let me see if I can alter my script..

ogautier62
Valued Contributor II

Re: Use the Box-Plot for time Analysis; Help required.

here is formula

and it looks like this :

I don't see with a boxplot (just two segments)

if you have some rows of data, attach them

omarbensalem
Esteemed Contributor

Re: Use the Box-Plot for time Analysis; Help required.

How would u include the dimension here?

I mean

3 bars for 3 values: Publication/Candidature/Service (supposing we have such a dimension)

and especially the count(ID)

ps: thank u very much for ur assistance

ogautier62
Valued Contributor II

Re: Use the Box-Plot for time Analysis; Help required.

et une expression pour mettre l'un des trois jours possibles :

if(valueloop(1,3)=1,sum(if( floor(nbj1/10)*10= valueloop(0,100,10),1) ),
if(valueloop(1,3)=2,sum(if( floor(nbj2/10)*10= valueloop(0,100,10),1) ),
if(plus-value(1,3)=3,sum(if( floor(nbj3/10)*10= valueloop(0,100,10),1) ))))

omarbensalem
Esteemed Contributor

Re: Use the Box-Plot for time Analysis; Help required.

Merci pour ton aide Olivier; ce fut vraiment d'un apport certain !

Here's what I did,

I've altered my script; now I have one dimension 'Action' that regroups the Candidature/publication and service)

I also have one Nb_deJours field

Based on that, I've created the class field in the script

Now my bar chart is as follow:

as Dimensions:

Class

Action

as a measure:

Nb_deJours

Result:

Capture.PNG

or

as Dimensions:

Action

Class

as a measure:

Nb_deJours

Result:

Capture.PNG

Thanks !

ogautier62
Valued Contributor II

Re: Use the Box-Plot for time Analysis; Help required.

merci Omar, bon développement