Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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?

 

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

View solution in original post

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