Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
rcorcoran
Contributor

Trend Analysis

Hi

I am trying to get the trend in the attached with an up arrow, down etc depending on the max month v previous month.

It has worked for me with a different metric that wasnt a percentage.  I think my brackets are wrong but cant seem to fix it.

Any help appreciated.

Table on attached file

Rhona

1 Solution

Accepted Solutions

Re: Trend Analysis

Hi Rhona,

Changed brackets in if, match and sum comparison clauses, also some brackets left in set analysis, check attachment to see if that's what you are looking for.

View solution in original post

2 Replies

Re: Trend Analysis

Hi Rhona,

Changed brackets in if, match and sum comparison clauses, also some brackets left in set analysis, check attachment to see if that's what you are looking for.

View solution in original post

rcorcoran
Contributor

Re: Trend Analysis

Hi Ruben

Thank you so much for your time this is perfect.

Rhona