issue in FirstsortedValue qliksense

berryandcherry6 — Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: issue in FirstsortedValue qliksense

ahaahaaha — Fri, 31 Mar 2017 08:05:35 GMT

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

topic issue in FirstsortedValue qliksense in QlikView

issue in FirstsortedValue qliksense

Re: issue in FirstsortedValue qliksense