Filtering out from SetAnalysis

[jpjust]

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

[AshutoshBhumkar]

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

[jpjust]

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