Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

calculation on X axis - qlik sense

Hiya

I have already a bar chart that shows how long in weeks a customer waits for a meeting

with Customer on x Axis and Number of weeks on Y axis.

the number of days they wait between meetings is in another column on table.

I wish to calculate number of weeks along x axis of bar chart,

and percentage of people on Y axis

this possible in sense?

please help

1 Solution

Accepted Solutions
brunobertels
Valued Contributor

Re: calculation on X axis - qlik sense

Hi Joanna

May this help :

a little sample adding number of weeks wait as dimension

Then adding the number of customer per each number of week wait divided by all the customer to get %

Regards

Bruno

4 Replies
MVP
MVP

Re: calculation on X axis - qlik sense

Its possible, but hard to give advice without knowledge of your data model. I suggest you provide more information and if possible, your app or a representative sample.

joeybird
Contributor II

Re: calculation on X axis - qlik sense

Hiya

unable to provide example app.

all I can provide is

that current bar chart currently shows on X axis = CustomerID ...ON Y axis shows number of weeks wait

as Avg(DaysSinceMeeting)/ 7

but I wish to show on Y axis, the number of weeks and , percentage of customers on X axis

Please help

brunobertels
Valued Contributor

Re: calculation on X axis - qlik sense

Hi Joanna

May this help :

a little sample adding number of weeks wait as dimension

Then adding the number of customer per each number of week wait divided by all the customer to get %

Regards

Bruno

joeybird
Contributor II

Re: calculation on X axis - qlik sense

Hiya

awesome thank you x

used too  (round("DaysSinceMeeting",7) / 7)