topic Re: Straight table format in QlikView

Straight table format

qlikviewwizard — Thu, 07 May 2015 08:56:25 GMT

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 — Thu, 07 May 2015 09:03:03 GMT

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 — Thu, 07 May 2015 09:13:59 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

qlikviewwizard — Thu, 07 May 2015 12:24:51 GMT

Thank you jagan and gwassenaar