topic Re: Problem with chart expression in QlikView

Problem with chart expression

Anonymous — Fri, 23 Oct 2015 12:52:42 GMT

Hi,

I am new to Qlikview and having the following problem. I've got a table_1 with fields model type, timeframe, revenue type and US$ and another Table_2 with those models, maintenance start and serial number.

What I'd like to do is to create a chart with dimensions of C_DATE and REVENUE TYPE and a expression that shows all models according to its maintenance start, which is related to C_DATE.

an Example - table_1:

Model timeframe revenue type US$

aaaa 10 change tires 50

bbbb 55 change window 30

Table_2:

Model Maintenance start Serial Number

aaaaa 12/10/2015 22

aaaaa 13/10/2015 23

bbbbb 10/5/2015 11

If anyone can help me I would appreciate.

thanks

Re: Problem with chart expression

sunny_talwar — Fri, 23 Oct 2015 14:51:21 GMT

I do see REVENUE TYPE field, but I don't see C_DATE in your example? Can you also share your desired output?

Re: Problem with chart expression

Anonymous — Fri, 23 Oct 2015 16:01:28 GMT

Yes!

C_DATE is a calendar containing all the dates from the year.

I drew a picture, attached.

Timeframe is given in days , so "maintenance start" plus "timeframe" equals to "day of maintenance".

Re: Problem with chart expression

Anonymous — Fri, 30 Oct 2015 10:15:13 GMT

Hi sunny. I had replied below.

In addition, I had also created a topic explaining better the desired result.

How to create another Column in script

Thanks