Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

Load Inline:How to show only required row from Inline Table

Hi,

i am Loading inline function as shown below

MetricsDimsMTD:

LOAD * INLINE [ 

      MetricsMTDRevenue 

    Invitations

    Landing Page Hits

    Sign-Ups

    Partial Completions

    Completions

    Completions Rate

    Revenue

];

code in front end is:

I am using Dimension : MetricsMTDRevenue 

Expression:

Num(if(MetricsMTDRevenue ='Invitations',Count({$<DateType = {invitation},client_id={'1'}>}invitation_id),

if(MetricsMTDRevenue='Landing Page Hits',count({$<DateType = {accessed},client_id={'1'}>}invitation_id),

if(MetricsMTDRevenue='Sign-Ups',sum({$<DateType = {signed},client_id={'1'}>}user_signed),

if(MetricsMTDRevenue='Partial Completions',(sum({$<DateType = {signed},client_id={'1'}>}user_signed)-sum({$< DateType = {completion},client_id={'1'},final_test_status={'passed'}>}course_completed)),

if(MetricsMTDRevenue='Completions',sum({$< DateType = {completion},client_id={'1'},final_test_status={'passed'}>}course_completed)

))))),if(MetricsMTDRevenue='Completions Rate','#,##0.0%', '#,##0'))

If i use above code it shows  Completions Rate and  Revenue  rows with empty data(or no data in that row).I want those rows to be hided or not shown. I need to show rows whatever the rows name i mention in expression.

How to do this.?

Tags (1)