Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zalemam1
New Contributor

How do you add multiple measurement in a pie chart?

Hi,

I'm trying to get my pie chart to display multiple measurements.

I'm trying to measure whether my SLA's are on target or past SLA, based on date calculation.

They're also sorted by Large effort and Small effort or if the values are null then "Project not assigned"

So I'm trying to display the following

=if([L0 Estimate Completion Date]<=[L0 Estimate Due Date] and [Estimation SLA Code] = 'Small', 'Small Project Within SLA',

if([L0 Estimate Completion Date]>[L0 Estimate Due Date] and [Estimation SLA Code] = 'Small', 'Small Project Past SLA',

if([L0 Estimate Completion Date]<=[L0 Estimate Due Date] and [Estimation SLA Code] = 'large', 'Large Project Within SLA',

if([L0 Estimate Completion Date]>[L0 Estimate Due Date] and [Estimation SLA Code] = 'large', 'Large Project Past SLA',

'Project not assigned date or size'))))

My code doesnt throw back an error, but the data its displaying is wrong.

Any help would be appreciated.

Thanks,

Zaid

Tags (1)
4 Replies
YoussefBelloum
Esteemed Contributor

Re: How do you add multiple measurement in a pie chart?

Hi,

can attach some screen shots to show the wrong result and what is the expected output ?

zalemam1
New Contributor

Re: How do you add multiple measurement in a pie chart?

pice chart.PNG

Pie chart is displaying values that are not null as null in "Project not assigned date or size"

None of the Large Project items are being captured.

ychaitanya
Contributor III

Re: How do you add multiple measurement in a pie chart?

Hello

Seems the logic is OK.. can you check the text if it;s matching to the values (ex: Small, large) ?

also . have you  tried passing this expr as DIM ?

YoussefBelloum
Esteemed Contributor

Re: How do you add multiple measurement in a pie chart?

Try to attach some rows here with every combination

Community Browser