Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Matrix Creation and usage

Hi, I am new to Qlikview and wanted to assistance to solve a particular issue.

Essentially trying to create a dynamic table basis averages of a criteria in a particular city. The value of the same can then be used for analysis similar to vlookup in excel.

The table based on the dynamic data will be something like below. The list of cities and criteria would vary as per the database and therefore dynamic in nature.

   

Criteria
City12345
A217875853123
B1235678974545
C123142786453786
D896546789625478
E7897853856345356
F78425378896786

eg The average value of criteria 1 in City A is 21 etc.

Now I take a particular row from the database and compare it against the table. Eg.Say criteria 1 for city A in the database is 32 and comparing it against the average 21 we can infer that the value is greater than the average.

Thereafter all those unique ID's where the amount is greater than say 25% of the averages from the table are displayed.

Please assist as to how to build the same.

Thanks in advance

1 Solution

Accepted Solutions
MVP
MVP

Re: Matrix Creation and usage

Wrong group - reply to this post instead:

Matrix Creation and usage

2 Replies
MVP
MVP

Re: Matrix Creation and usage

Wrong group - reply to this post instead:

Matrix Creation and usage

Not applicable

Re: Matrix Creation and usage

Thanks Jonathan... still trying to get my way arounf this place.

Apologies for any inconvenience caused.