Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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
Partner

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