Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

MTA

HI,

i want to make an mta graph like this:

מציג את image001.png

what object should i use?

someone have an example for somthing similar?

adi

9 Replies
sunny_talwar

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

Best,

Sunny

adiarnon
Creator III
Creator III
Author

unnamed.jpg

swarup_malli
Specialist
Specialist

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.

MarcoWedel

Could also be a scatter plot.

Can you provide sample data/app?

Regards

Marco

MarcoWedel

Hi,

QlikCommunity_Thread_168986_Pic1.JPG

QlikCommunity_Thread_168986_Pic2.JPG

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

adiarnon
Creator III
Creator III
Author

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??

Not applicable


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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

MarcoWedel

Hi Peter,

nice solution, thank you.

Here my approach:

QlikCommunity_Thread_168986_Pic3.JPG

QlikCommunity_Thread_168986_Pic4.JPG

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