topic Re: Dimension interval in QlikView

Dimension interval

ali_hijazi — Mon, 16 Jun 2014 12:08:25 GMT

hello

I have two expressions on a line chart

on the x-axis I want to show values that range from 0 till 12

How can I attain this?

Please advise

Re: Dimension interval

Mon, 16 Jun 2014 12:09:15 GMT

can you tell us what your x axis expression is?

Re: Dimension interval

ashfaq_haseeb — Mon, 16 Jun 2014 12:16:27 GMT

Hi Ali,

Use below as calculated dimension.

=ValueLoop(1,12)

Regards

ASHFAQ

Re: Dimension interval

ali_hijazi — Mon, 16 Jun 2014 12:18:41 GMT

well I'm working on a Quality Control system where defects have a fix period (fix date - release date in number of months), and a defect period (defect date - release date in number of months)

my expressions will count the number of defects but the first need to draw the count group by fix period and the other expression needs to draw the line that show the count group by defect period

Re: Dimension interval

ali_hijazi — Mon, 16 Jun 2014 12:25:58 GMT

let's say my expression is count(defects)

I want to show two lines one by how many months it took to be fixed after release date and the other by how many months the defect was created after the release date

and the number of months is the x axis that ranges from 1 till 12

Re: Dimension interval

ashfaq_haseeb — Mon, 16 Jun 2014 12:51:22 GMT

Hi Ali, In this case create a field in back-end as below

num(month(YourDate)) as Month_Num.

Create a chart by selecting

Month_Num as dimension, make sure you selected show all values and suppress when value is null.

then write your two expressions.

Hopefully should solve your issue.

If it does not help try by sharing app.

Regards

ASHFAQ

Re: Dimension interval

ali_hijazi — Mon, 16 Jun 2014 12:54:02 GMT

no the x axis shall show the number of months after the release date not the month number

Re: Dimension interval

Mon, 16 Jun 2014 19:33:34 GMT

Hi Ali, If you want create the Dimensional Interval, You the Class function. But Class function is not fit to ur requirement.

Please post some sample data

Re: Dimension interval

ali_hijazi — Tue, 17 Jun 2014 06:38:41 GMT

i know the class function will classifiy result into ranges on the x-axis

Re: Dimension interval

Tue, 17 Jun 2014 06:40:48 GMT

=ValueList(1,2,3,4,5,6,7,8,9,10,11,12)

Re: Dimension interval

jonathandienst — Tue, 17 Jun 2014 07:05:33 GMT

How about:

=(Year(DefectDate) - Year(SellDate)* 12 + (Month(DefectDate) - Month(SellDate))

=(Year(FixDate) - Year(SellDate)* 12 + (Month(FixDate) - Month(SellDate))

It would be simpler if QV had a DateDiff function like SQL:)

HTH

Jonathan