topic Re: line chart with common x-axis for two expressions in QlikView

line chart with common x-axis for two expressions

ali_hijazi — Mon, 16 Jun 2014 12:52:42 GMT

hello

got the followng sample data

Defect ID Fix Period Defect Period

1 1 0.5

2 1 1

3 2 1.25

...

I need to have a line chart with x-axis having values that range between 1 and 12

the chart need to show two types of lines one showing the number defects by Fix period and the other by defect period both on the common axis

is this doable?

Re: line chart with common x-axis for two expressions

Anonymous — Mon, 16 Jun 2014 15:11:06 GMT

Hi Ali,

Your x-axis is represented by which field in your table?

Antoine

Re: line chart with common x-axis for two expressions

ali_hijazi — Tue, 17 Jun 2014 06:09:50 GMT

here is the difficulty

I want same axis for two expressions

Re: line chart with common x-axis for two expressions

Anonymous — Tue, 17 Jun 2014 07:23:42 GMT

Ali,

Still, which will you use as an x axis? Defect ID? Fix Period? Defect Period?

What are you trying to represent? You could attach a picture...

Cheers,

Antoine

Re: line chart with common x-axis for two expressions

Tue, 17 Jun 2014 07:34:21 GMT

Is this what are you looking for ?

PFA

Re: line chart with common x-axis for two expressions

jonathandienst — Tue, 17 Jun 2014 07:34:52 GMT

Create an data island for your dimension:

MonthIsland:

LOAD RowNo() As isMonths AutoGenerate 12;

Now use:

= Count(Distinct If(Round([Fix Period]) = isMonths, [Defect ID])

= Count(Distinct If(Round([Defect Period]) = isMonths, [Defect ID])

for your expressions.

HTH

Jonathan

PS: you could use ValueList but I prefer to create the dimension as shown above

Re: line chart with common x-axis for two expressions

ali_hijazi — Tue, 17 Jun 2014 08:16:32 GMT

if I want to use ValueList

then round([Fix Period]) will be compared to which value?

please advise

Re: line chart with common x-axis for two expressions

ali_hijazi — Tue, 17 Jun 2014 08:31:42 GMT

but still I need the line to show at 0.5, and 1.25 for defect period

please advise