Ignore selection in expression but I need to still that selection should effect dimension

[berkarmagan]

Hi everyone,

I want to count my customers with ignoring year and month selection, i need whole customers count with aggrgeriton when needed with related dimensions - which year and month is not related- for example centraloffice id is related.

I add 2 ss below, when I try to count({<SalesYear=>}distinct CustomerCode) in table object, if i put year as a dimension then table shows all years which i dont want to see in this object. {1} also doesnt fit for my problem. I tried this:

count(distinct aggr(max({<SalesYear>}CustomerCode),'selecteddimension'))-> it still needs to get {<SalesYear>} in the count func then it shows all salesyears on the raws 

I tried P function and it didnt solve my problem either.

And also I tried to give my exppresion into set analysis, which is like count({<CustomerCode= {"=count({<SalesYear>}distinct CustomerCode)>0"}>} distinct CustomerCode), it still affecting by year selections..

What i need is, count all customers by centraloffice with ignoring year selection but I dont need to see whole years on the table when I select just one year..

If you have any idea i ll be gratefull, thanks for now

this ss is calculating true for centrol office on dimension

when I add Year as a dimension, calculation doesn't work, IF i pick 2021 in year, I should just see the table as above with year column with just 2021.

[Ksrinivasan]

hi,

pl, provide your expected result from two example table.

ksrini

[berkarmagan]

I add more detail to main question

[Ksrinivasan]

hi,

sry,

please explain how you get this result from your table:

Input Table1:

Input Table2:

Note: 

try this link

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

ksrini