topic Re: Filtering out from SetAnalysis in App Development

Filtering out from SetAnalysis

jpjust — Tue, 26 Oct 2021 17:17:07 GMT

Hi,

I have an issue below.

Here is my table.

App Name Stream App Publish Date

App-A Stream A 2021-10-26

App-B Unpublished Never

Now my App Name expression is =Aggr(Only({<[App Publish Date] = {'$(=Date(Today(),'YYYY-MM-DD'))'}, [App Stream] -= {'Unpublished'}>}[App Name]),[App Name])

The Unpublished record is not going away. Any idea what could be the issue with the above set analysis expression?

If there is any other way of excluding Unpublished, please let me know.

Thanks

Re: Filtering out from SetAnalysis

AshutoshBhumkar — Tue, 26 Oct 2021 17:46:33 GMT

Hello,

Using below expression will remove data from that dimension only. an not the entire row.

Now my App Name expression is =Aggr(Only({<[App Publish Date] = {'$(=Date(Today(),'YYYY-MM-DD'))'}, [App Stream] -= {'Unpublished'}>}[App Name]),[App Name]).

You can try below expression.

=Count({<[App Publish Date] = {"$(=Date(Today(),'YYYY-MM-DD'))"}, Stream -= {'Unpublished'}>}[App Name])

Thanks,

Ashutosh

Re: Filtering out from SetAnalysis

jpjust — Tue, 26 Oct 2021 18:24:33 GMT

Thanks Ashutosh for that expression.

Unfortunately, the output is like this for me.

App Name Stream App Publish Date count(Measure

App-A Stream A 2021-10-26 24

App-B Unpublished Never 0

The record still stays on my qliksense table.

Thanks