Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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