Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rcandeo
Contributor II

how can I show this information?

Hi,sorry to ask again but I need so much solve this please.

I need to show information like this:

Type          Position in the Rank          Ranking Change              Value Change

Overall                    5                                  -2                              -18,5%

UK                        10                                  3                                5,5%

Italy                        15                                  0                              -7,3%

I seems easy but it is all depending of rank calculation

In the attached file I´ve created 3 dynamic tables but if there is no other way to visualize, I need at least in the second and thirdy one see only the last column with the results.

Who can give me a hint to show this better?

1 Solution

Accepted Solutions
MVP
MVP

Re: how can I show this information?

Looking to get this?

Capture.PNG

Added a table in the script:

Dim:

LOAD * Inline [

Dim

1

2

3

];

Dimensions

Broker Group Name

Dim

Expression (Just showing the 1st one, rest can be see in the attached application)

Pick(Dim,

Rank(Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP])) * Avg(1),

Rank(Sum({1<[Reporting Calendar Year]={'$(vYearBefore)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP])) * Avg(1)

-

Rank(Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP])) * Avg(1),

Num(Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP]) * Avg(1)

/

Sum({1<[Reporting Calendar Year]={'$(vYearBefore)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP]) * Avg(1)

-1, '##,0%'))

4 Replies
MVP
MVP

Re: how can I show this information?

Looking to get this?

Capture.PNG

Added a table in the script:

Dim:

LOAD * Inline [

Dim

1

2

3

];

Dimensions

Broker Group Name

Dim

Expression (Just showing the 1st one, rest can be see in the attached application)

Pick(Dim,

Rank(Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP])) * Avg(1),

Rank(Sum({1<[Reporting Calendar Year]={'$(vYearBefore)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP])) * Avg(1)

-

Rank(Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP])) * Avg(1),

Num(Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP]) * Avg(1)

/

Sum({1<[Reporting Calendar Year]={'$(vYearBefore)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP]) * Avg(1)

-1, '##,0%'))

rcandeo
Contributor II

Re: how can I show this information?

Thank You so so much! This is perfect for me.

Best Regards

rcandeo
Contributor II

Re: how can I show this information?

You built all the expressions!! I´m so ashamed you had this work for me. Anything you need help, count on me ok?

You´re the best

MVP
MVP

Re: how can I show this information?

Don't have to be ashamed my friend, you did not force me to do this, I just thought that I should complete what I have started .

Best,

Sunny