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: 
joeybird
Creator III
Creator III

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

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

View solution in original post

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
joeybird
Creator III
Creator III
Author

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

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
Creator III
Creator III
Author

Hiya

awesome thank you x

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