topic Re: Adding some custom lines in my chart in QlikView

Adding some custom lines in my chart

Wed, 24 Aug 2011 15:02:24 GMT

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?

Adding some custom lines in my chart

its_anandrjs — Wed, 24 Aug 2011 15:18:14 GMT

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

Re: Adding some custom lines in my chart

Wed, 24 Aug 2011 20:29:00 GMT

anandrjs thx for reply.

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

Adding some custom lines in my chart

its_anandrjs — Thu, 25 Aug 2011 07:26:23 GMT

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

Re: Adding some custom lines in my chart

Thu, 25 Aug 2011 13:14:38 GMT

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.

Re: Adding some custom lines in my chart

Mon, 29 Aug 2011 06:06:37 GMT

Anybody?

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

Re: Adding some custom lines in my chart

Mon, 29 Aug 2011 09:33:37 GMT

Hi,

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

Niranjan M.

Re: Adding some custom lines in my chart

Tue, 30 Aug 2011 07:41:54 GMT

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.