issue in FirstsortedValue qliksense

[berryandcherry6]

Hi,

i am using FirstSortedValue in Bar Chart, to get data for latest expired campaign for batch

I am confused using it in Bar chart,

If latest expired campaign exist for batch it shows data otherwise it shows nothing. i need it to show 0 value if no latest expired campaign exists(i.e if  no data exists)

$(=FirstSortedValue({$<batch_meta_data_id={'53'}, campaign_end_date = {"$(='<' & Date(Today(),'MM-DD-YYYY'))"}>}

Aggr(Sum({$<batch_meta_data_id={'53'}>}sign_up), campaign_end_date), -Aggr(campaign_end_date, campaign_end_date)))

I tried using alt, but it is not working

alt(($(=FirstSortedValue({$<batch_meta_data_id={'53'}, campaign_end_date = {"$(='<' & Date(Today(),'MM-DD-YYYY'))"}>}

Aggr(Sum({$<batch_meta_data_id={'53'}>}sign_up), campaign_end_date), -Aggr(campaign_end_date, campaign_end_date)))),0)

[ahaahaaha]

Hi,

maybe so

$(=FirstSortedValue({$<batch_meta_data_id={'53'}, campaign_end_date = {"$(='<' & Date(Today(),'MM-DD-YYYY'))"}>}

Aggr(Sum({$<batch_meta_data_id={'53'}>}sign_up), campaign_end_date), Rank(-Aggr(campaign_end_date, campaign_end_date), 1)))

Regards,

Andrey