Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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