not affected by filtering

bsrgln — Fri, 02 Dec 2022 15:59:44 GMT

Hello,

I have 2 different files named 'Previous' and 'Current' where I get my data.

I have defined 1 as Deleted_Flag in my script load editor to help understand where my data comes from.

In the below script, I am aiming to count the SKU Name if it's exist only in the file called 'Current'.

=count(if(aggr(sum(Deleted_Flag), [SKU Name])=1 and [Current or Previous]='Current', [SKU Name]))

It works, but it's affected by user selection. I want to have an exact value in there and it should not be affected any selection. I know we can use {1} as amodifier in set analysis but I couldn't adopt this script to set analysis format.

Could you please advise me how can I avoid any user selection?

Thanks

Re: not affected by filtering

RafaelBarrios — Sun, 04 Dec 2022 12:42:03 GMT

hi @bsrgln

You can try alternate states, so one part of your formula works with some filters while not affecting other

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Visualizations/alternate-states-comparative-analysis.htm

here you have more Set Analysis options

Hope this helps.

Best,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 😁

topic Re: not affected by filtering in App Development

not affected by filtering

Re: not affected by filtering