topic Re: calculation on X axis - qlik sense in App Development

calculation on X axis - qlik sense

joeybird — Fri, 30 Oct 2015 10:48:59 GMT

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

Re: calculation on X axis - qlik sense

jonathandienst — Fri, 30 Oct 2015 10:54:40 GMT

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.

Re: calculation on X axis - qlik sense

joeybird — Fri, 30 Oct 2015 10:59:43 GMT

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

Re: calculation on X axis - qlik sense

brunobertels — Fri, 30 Oct 2015 13:57:05 GMT

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

Re: calculation on X axis - qlik sense

joeybird — Fri, 30 Oct 2015 15:20:56 GMT

Hiya

awesome thank you x

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