Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: MTA

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

Best,

Sunny

Highlighted
Creator III
Creator III

Re: MTA

unnamed.jpg

Highlighted
Specialist
Specialist

Re: MTA

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.

Highlighted

Re: MTA

Could also be a scatter plot.

Can you provide sample data/app?

Regards

Marco

Highlighted

Re: MTA

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

Highlighted
Creator III
Creator III

Re: MTA

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

Highlighted
Not applicable

Re: MTA


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

Highlighted

Re: MTA

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

Highlighted

Re: MTA

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