topic Re: min aggr for all feild on cyclegroup dimension in chart in QlikView

min aggr for all feild on cyclegroup dimension in chart

marjan_it — Sat, 16 Nov 2024 17:45:57 GMT

Hi all

I have a chart with a cyclegroup dimension and an expression to calculate Min(all Aggr(Count(Code),Region ))

I want that this calculation changes by changing the dimension group and if I change dimension to date it calculate s

Min(all Aggr(Count(Code),Date)).

how can I do?

MayilVahanan — Sun, 29 Nov 2020 08:15:28 GMT

Try like below

Min(Aggr(Count(Code),$(=GetCurrentField([New Group]))))

marjan_it — Mon, 30 Nov 2020 06:35:39 GMT

Thanks so much, but I have another question, If we want to add a condition in expression to say that

count(if(GetCurrentField([New Group]))=Date ,Code)) How to do it?

MayilVahanan — Mon, 30 Nov 2020 08:35:31 GMT

Try like below

count(if(GetCurrentField([New Group])='Date' ,Code))

pls use @name to get notification or create new thread