Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression help

Hi,

Hoping for some help. I rasied a question a while ago for help with a calculation. I was kindly provided with the following expression to calculate decency. It workes, in that it provided a figure and matches at an overall level; however, when I then click our neighbourhood filter it doesn't then match the detail:

Num(Count ({<[Decency]= {Decent}>} [Decency])/ Count({1} [Decency]), '#,##0.00%') 

So to clarify when looking at figures overall the expression below matches the detail:

Overall

Decency                              Count                 %

Decent                                    4376             30.01%

Non decnt                                 199             1.36%

Potnetially Non Decent        10009           68.63%

However, when selecting a neighbourhood no longer works:

In Monton and Ellesmere we have the following breakdown; however, the expression above gives us a figure of 0.77%:

Decency                              Count             %

Decent                                    112           18.54%

Non decnt                                 52           8.61%

Potnetially Non Decent          440        72.85%

...?

1 Solution

Accepted Solutions
Not applicable
Author

Hi Chris,


Count({1} [Decency]  will give always the full count of decency.

If you want it to work with selection use  Count(total [Decency] )


best regards

Chris

View solution in original post

1 Reply
Not applicable
Author

Hi Chris,


Count({1} [Decency]  will give always the full count of decency.

If you want it to work with selection use  Count(total [Decency] )


best regards

Chris

View solution in original post