Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
marjan_it
Creator III
Creator III

min aggr for all feild on cyclegroup dimension in chart

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?

 

Labels (5)
1 Solution

Accepted Solutions
MayilVahanan

HI @marjan_it 

Try like below

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

Thanks & Regards,
Mayil Vahanan R

View solution in original post

3 Replies
MayilVahanan

HI @marjan_it 

Try like below

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

Thanks & Regards,
Mayil Vahanan R
marjan_it
Creator III
Creator III
Author

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

Hi @marjan_it 

Try like below

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

pls use @name to get notification or create new thread

Thanks & Regards,
Mayil Vahanan R