topic Re: Displaying values in a straight table on certain selection in QlikView

Displaying values in a straight table on certain selection

Tue, 12 Nov 2013 06:31:50 GMT

Hi,

I have a requirement wherein I have to display the metric names,status1,status2 and sales in a chart wherein status1 and status2 must appear as images.I have acheived this,but the issue is that the chart is not providing the summarised view of the data.i.e.,

In my application i have four Metrics A,B,C,D and thus i would want to see only four rows in my chart,one for each metric name, with status1 and status2 displaying null value when no selection is being made on year and month, and once the selection is made on the year and month i would want the chart to display the values for Status1 and status2.Can anyone please help acheive this

I have also attached the sample application

Re: Displaying values in a straight table on certain selection

kaushiknsolanki — Tue, 12 Nov 2013 06:39:36 GMT

Hi,

Have a look at the application.

Regards,

Kaushik Solanki

Re: Displaying values in a straight table on certain selection

sasikanth — Tue, 12 Nov 2013 07:09:19 GMT

HI anu

Kaushik Solanki`s example is perfect ,

if you want to enable the status,status2 based on only My_date field.. Then use

enable condition as GetSelectedCount(My_data)>0.

Re: Displaying values in a straight table on certain selection

Tue, 12 Nov 2013 07:13:28 GMT

Hi Kaushik,

In the application put up, you have made the columns status1 and status2 to appear only when month is selected.But I would want to display the columns status1 and status2 even when the month is not selected.But it must be having Null Values (i.e., '-') when no values are selected.Can you please let me know how this could be acheived.

Re: Displaying values in a straight table on certain selection

kaushiknsolanki — Tue, 12 Nov 2013 07:17:11 GMT

Hi,

Write the calculated expression as

=if(isnull(GetCurrentSelections()),Null(),

if(Status='GREEN','qmem://<bundled>/BuiltIn/led_g.png',

if(Status='RED','qmem://<bundled>/BuiltIn/led_r.png',

if(Status='YELLOW','qmem://<bundled>/BuiltIn/led_y.png'))))

And remove the Enable condition.

Regards,

Kaushik Solanki