not affected by filtering

[bsrgln]

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

[RafaelBarrios]

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/alter...

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! 😁