Straight table format

[qlikviewwizard]

Hi Folks,

How to show in straight table with the two measures and status images as shown image ans app.

Need the following format:

-Status should be shown last column of the report, but it is repeating for each B value.

-Range Sum for Q1 is not required as Q1 SAL and its Range sum both are same.

-Range Sum labels to be shown dynamically like  Q1 Sum,Q1+Q2 Sum,Q1+Q2+Q3 Sum,Q1+Q2+Q3+Q4 Sum

Please help me.

Thanks in advance.

[Gysbert_Wassenaar]

Change your Status expression to:

     if(SecondaryDimensionality()=0,

     if(sum(SAL)<40, 'qmem://<bundled>/BuiltIn/led_r.png',

     if(sum(SAL)>=40 and sum(SAL)<60, 'qmem://<bundled>/BuiltIn/led_y.png',

     if(sum(SAL)>=60, 'qmem://<bundled>/BuiltIn/led_g.png'))))

The Rangesum column cannot be hidden for only Q1. It will be shown for all QUARTER dimension values.

An expression can have only one Label value. It will be the same for all QUARTER dimension values.

[jagan · Accepted solution]

Hi,

Please find attached file for solution.

Regards,

Jagan.

[qlikviewwizard]

Thank you jagan and gwassenaar