Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

moving annual, year to date, last 6months, 3months, monthly on same graph

Hi there,

I'm trying to replicate this graph but its proving tricky. Does anyone have an example of how to do this?

The graph shows Market Growth vs Product Growth and product share

Thanks,

7 Replies
Highlighted
Not applicable

Re: moving annual, year to date, last 6months, 3months, monthly on same graph

Hi,

Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

Create an inline function with the same fields as above and do not link to any other table.

eg:

Load * Inline [

ID,Value

1, Moving Annual

2, Year To Date

3, Last 6 Months ];

Use the inline fields as dimension eg: Value fields in dimension

In expression by giving each condition evaluating with Inline value field you have to write expression

eg:

if(ID=1,sum(Moving Annual)

if(ID=2, sum(Year To Date)))

etc...

Hope it helps for your query.

Chenna

Highlighted
Not applicable

Re: moving annual, year to date, last 6months, 3months, monthly on same graph

Hi,

Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

Create an inline function with the same fields as above and do not link to any other table.

eg:

Load * Inline [

ID,Value

1, Moving Annual

2, Year To Date

3, Last 6 Months ];

Use the inline fields as dimension eg: Value fields in dimension

In expression by giving each condition evaluating with Inline value field you have to write expression

eg:

if(ID=1,sum(Moving Annual)

if(ID=2, sum(Year To Date)))

etc...

Hope it helps for your query.

Chenna

Highlighted
Not applicable

Re: moving annual, year to date, last 6months, 3months, monthly on same graph

Hi,

Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

Create an inline function with the same fields as above and do not link to any other table.

eg:

Load * Inline [

ID,Value

1, Moving Annual

2, Year To Date

3, Last 6 Months ];

Use the inline fields as dimension eg: Value fields in dimension

In expression by giving each condition evaluating with Inline value field you have to write expression

eg:

if(ID=1,sum(Moving Annual)

if(ID=2, sum(Year To Date)))

etc...

Hope it helps for your query.

Chenna

Highlighted
Not applicable

Re: moving annual, year to date, last 6months, 3months, monthly on same graph

Hi,

Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

Create an inline function with the same fields as above and do not link to any other table.

eg:

Load * Inline [

ID,Value

1, Moving Annual

2, Year To Date

3, Last 6 Months ];

Use the inline fields as dimension eg: Value fields in dimension

In expression by giving each condition evaluating with Inline value field you have to write expression

eg:

if(ID=1,sum(Moving Annual)

if(ID=2, sum(Year To Date)))

etc...

Hope it helps for your query.

Chenna

Highlighted
Not applicable

Re: moving annual, year to date, last 6months, 3months, monthly on same graph

Hi,

Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

Create an inline function with the same fields as above and do not link to any other table.

eg:

Load * Inline [

ID,Value

1, Moving Annual

2, Year To Date

3, Last 6 Months ];

Use the inline fields as dimension eg: Value fields in dimension

In expression by giving each condition evaluating with Inline value field you have to write expression

eg:

if(ID=1,sum(Moving Annual)

if(ID=2, sum(Year To Date)))

etc...

Hope it helps for your query.

Chenna

Highlighted
Not applicable

Re: moving annual, year to date, last 6months, 3months, monthly on same graph

Hi,

Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

Create an inline function with the same fields as above and do not link to any other table.

eg:

Load * Inline [

ID,Value

1, Moving Annual

2, Year To Date

3, Last 6 Months ];

Use the inline fields as dimension eg: Value fields in dimension

In expression by giving each condition evaluating with Inline value field you have to write expression

eg:

if(ID=1,sum(Moving Annual)

if(ID=2, sum(Year To Date)))

etc...

Hope it helps for your query.

Chenna

Highlighted
Not applicable

Re: moving annual, year to date, last 6months, 3months, monthly on same graph

Hi,

Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

Create an inline function with the same fields as above and do not link to any other table.

eg:

Load * Inline [

ID,Value

1, Moving Annual

2, Year To Date

3, Last 6 Months ];

Use the inline fields as dimension eg: Value fields in dimension

In expression by giving each condition evaluating with Inline value field you have to write expression

eg:

if(ID=1,sum(Moving Annual)

if(ID=2, sum(Year To Date)))

etc...

Hope it helps for your query.

Chenna