topic Re: MTA in QlikView

MTA

adiarnon — Thu, 18 Jun 2015 13:53:08 GMT

HI,

i want to make an mta graph like this:

what object should i use?

someone have an example for somthing similar?

adi

Re: MTA

sunny_talwar — Thu, 18 Jun 2015 14:03:21 GMT

The image isn't showing up, you might have to repost the image.

Best,

Sunny

Re: MTA

adiarnon — Sun, 21 Jun 2015 04:31:38 GMT

Re: MTA

swarup_malli — Sun, 21 Jun 2015 04:42:18 GMT

You can use a Line chart to imitate your chart.For grids and the dashed diagonal line you will have to use an image as background for the line chart.

Re: MTA

MarcoWedel — Sun, 21 Jun 2015 08:50:25 GMT

Could also be a scatter plot.

Can you provide sample data/app?

Regards

Marco

Re: MTA

MarcoWedel — Sun, 21 Jun 2015 22:38:11 GMT

Hi,

tabTemp:
LOAD 'Category '& RecNo() as Category,
    Date(MakeDate(2015)+Ceil(Rand()*60)) as Date
AutoGenerate 5;

table1:
LOAD Category,
    IterNo() as ID,
    Date(Date+(IterNo()-1)*7) as Date1,
    Date(Date+45+(Rand()-0.5)*10) as Date2
Resident tabTemp
While IterNo()<=Rand()*4+4;

LOAD 'bisector' as Category,
    1 as ID,
    *;
LOAD MonthStart(Min(RangeMin(Date1,Date2))) as Date1,
    MonthStart(Min(RangeMin(Date1,Date2))) as Date2
Resident table1;

LOAD 'bisector' as Category,
    2 as ID,
    *;
LOAD MonthEnd(Max(RangeMax(Date1,Date2))) as Date1,
    MonthEnd(Max(RangeMax(Date1,Date2))) as Date2
Resident table1;   
   
DROP Table tabTemp;

hope this helps

regards

Marco

Re: MTA

adiarnon — Thu, 25 Jun 2015 07:10:14 GMT

hi,

i did it with a line chart.

but now i want that the color of each line will be according to another dimnsion.

for exe-

each line represent a task

anf i want that the color of the line will be according to the project that the task in.

how can i do that??

Re: MTA

Thu, 25 Jun 2015 13:07:13 GMT

Line chart properties--> expression --> refer snapshot

Re: MTA

Peter_Cammaert — Thu, 25 Jun 2015 13:55:14 GMT

Marco,

legends at the end of the graph line instead of in a separate legend box is demonstrated by Stephen Redmong in his QlikView For Developers Cookbook (p38) and also here in his blog: Qlik Tips: Lose the Legend in Line Charts

Peter

Re: MTA

MarcoWedel — Thu, 25 Jun 2015 22:06:36 GMT

Hi Peter,

nice solution, thank you.

Here my approach:

tabTemp:
LOAD 'Category '& RecNo() as Category,
    Date(MakeDate(2015)+Ceil(Rand()*60)) as Date
AutoGenerate 5;

table1:
LOAD Category,
    AutoNumberHash128(IterNo(),RecNo()) as ID,
    Date(Date+(IterNo()-1)*7) as Date1,
    Date(Date+45+(Rand()-0.5)*10) as Date2
Resident tabTemp
While IterNo()<=Rand()*4+4;

LOAD 'bisector' as Category,
    AutoNumberHash128(1,'bisector') as ID,
    *;
LOAD MonthStart(Min(RangeMin(Date1,Date2))) as Date1,
    MonthStart(Min(RangeMin(Date1,Date2))) as Date2
Resident table1;

LOAD 'bisector' as Category,
    AutoNumberHash128(2,'bisector') as ID,
    *;
LOAD MonthEnd(Max(RangeMax(Date1,Date2))) as Date1,
    MonthEnd(Max(RangeMax(Date1,Date2))) as Date2
Resident table1;   
   
DROP Table tabTemp;

Left Join (table1)
LOAD Category,
    Max(ID) as ID,
    1 as IsLastID
Resident table1
Group By Category;

hope this helps

regards

Marco