Adding some custom lines in my chart

[#1]

Hi.

I have chart with 2 dimension and 2 expression columns. In this chart I need to add 3 lines(one above(first line in chart) and two at the end). If you want analogy - like total line, but calculated thru custom expression and it have to be 3 of them, not just one top or buttom.

I think it can be achived thru pseudo data in load script:

concantinate
load field1, field2, val
inline [
     field1, field2, val
     '-','Custom line1',0
     '-','Custom line2',0
     '-','Custom line3',0
];

But may be it can be solved thru calculated dimendions or some other way?

[its_anandrjs]

Hi,

As i understand it you want to add a perticular calculated line if this so i suggest you use the Reference lines or Text in chart option from there you calculate your value also.

From Presentation tab you get all this settings.

Regards

Anand

[#3]

anandrjs thx for reply.

Sorry for my english. I am using Straight Table Chart. By line i mean row of data in table.

[its_anandrjs]

Hi,

A type of row means single row which type of it is ,could you clear it more, do you have any sample file please share it.

Regards,

Anand

[#5]

Ok.

I need table like this

Bold rows is what i desire

Hire is my test file and data soure. Note that there is only one client, in real data model there is 1000+ and expressions is slightly difrent, but idea is same.

[#6]

Anybody?

At least give me direction how you should make that kind of things in qlikview.

[#7]

Hi,

I achieved as said please go through the attached qvw file.

Niranjan M.

[#8]

Thx for reply Niranjan.

I did simular thing. But there is several problems:

1. If you select particular client this special rows wold not be displayed.

2. If you chose date "from" earlier than 1st record you get "-"(null data) instead needed 1st row. Simular thing with "To" date.

I will try to resolv them in near future.