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

berkarmagan — Sat, 16 Nov 2024 17:26:08 GMT

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.

Re: Ignore some selection in expression but want to still affect dimension

Ksrinivasan — Tue, 02 Mar 2021 08:42:55 GMT

hi,

pl, provide your expected result from two example table.

ksrini

Re: Ignore some selection in expression but want to still affect dimension

berkarmagan — Tue, 02 Mar 2021 11:40:47 GMT

I add more detail to main question

Re: Ignore some selection in expression but want to still affect dimension

Ksrinivasan — Tue, 02 Mar 2021 10:46:01 GMT

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/SetAnalysis/set-analysis-expressions.htm

ksrini

topic Re: Ignore some selection in expression but want to still affect dimension in App Development

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

Re: Ignore some selection in expression but want to still affect dimension

Re: Ignore some selection in expression but want to still affect dimension

Re: Ignore some selection in expression but want to still affect dimension