Qlik Sense Expression.

[Intrepid]

I have this expression that I am using on a bar graph.  There are four Field

Names,



If(Aggr(Count({<[Field Name (Y/N)] = {"Y"}>}[Field Name (Y/N)], >4, 1,0)



I am getting the correct results in the bar graph from this expression, but I

need to count the result of just the 1's and place them into a pie chart that shows the

percentage in Qlik Sense.

[rubenmarin]

Hi, that expression doesn't have a parameter for the aggr, and has a comma before >4, can you check the expression?

Or try with something like: Sum(Aggr(If(Count({<[Field Name (Y/N)] = {"Y"}>}[Field Name (Y/N)])>4, 1,0), AggrDimension))

[Intrepid]

Thxs for the reply Rubenmarin, I will try your suggestion soon, I have been working another project for the last couple days. I will let you know if that did the trick for me soon.... THXS for your time... Stan