Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
yuvraj_33
New Contributor III

One Dimension value static & other variable in TOP analysis

Hi All,

I have this query wherein I need to implement a top 5 analysis in bar chart where one value is static & others vary as per selections.

e.g.: Suppose I have 10 materials as follows.

-----------------------------------------

Material    |    Sale

-----------------------------------------

      Pen     -    40

    Pencil    -    30

    Eraser   -    60

Sharpener  -    70

    Colors   -    50

  Palette    -    10

Notebook  -    20

Textbook  -    100

    Brush   -    80

Compass  -    90

-----------------------------------------

I need to show top 5 Sale for Materials as Colors + Top 5 which makes overall 6 values.

Here, Material = 'Colors' should be constant & Top 5 from remaining  9 materials.

So, as per requirement the output should be in following sequence in a bar chart:

1. Colors      -     50

2. Textbook  -     100

3. Compass  -     90

4. Brush       -     80

5. Sharpener -     70

6. Eraser      -     60

Please suggest over the same.

Tags (2)