Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
datashaw
New Contributor III

Count the percentages only if its dropped to certain value

Dear Experts,

I'm looking for some assistance  to show the count in straight table expression please.

I want to show the count of percentages, only  if the percentage is dropped below 50%

  
=Count({<Status-={'REJECTED'},Code ={'AP'} Items) / Count({<({<Status-={'REJECTED'}>}Items))
The above expression gives me 40%  so my count is 1.

 I'm trying to execute the Count of items if less than 50% 

example
Dimension= Date, Product
Expression Count of items if the above expression is >50% Items)

hope you understand the requirement and kindly suggest me the solution please 

5 Replies

Re: Count the percentages if its dropped to certain level

Perhaps this?

=Count({<Items={"=Num(Count(Items), '#,#0%')<0.5"}, Status-={'REJECTED'},Code ={'AP'} Items) / Count({<Items={"=Num(Count(Items), '#,#0%')<0.5"}, {<Status-={'REJECTED'}>}Items)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
datashaw
New Contributor III

Re: Count the percentages if its dropped to certain level

No luck 😞

Re: Count the percentages if its dropped to certain level

This syntax wrong, My bad. correct one is this?

=Count({<Items={"=Num(Count(Items), '#,#0%')<0.5"}, Status-={'REJECTED'},Code ={'AP'}>} Items) / Count({<Items={"=Num(Count(Items), '#,#0%')<0.5"}, Status-={'REJECTED'}>}Items)

Or

=Sum({<Items = {"=(Count({<Status-={'REJECTED'},Code ={'AP'}>} Items) / Count({<Status-={'REJECTED'}>}Items))<0.5"}>} Aggr(NODISTINCT Count({<Status-={'REJECTED'},Code ={'AP'}>} Items) / Count({<Status-={'REJECTED'}>}Items), Items))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
datashaw
New Contributor III

Re: Count the percentages if its dropped to certain level

The given expression does not give me a count. 

please help me with the right expression.


=Sum({<Items = {"=(Count({<Status-={'REJECTED'},Code ={'AP'}>} Items)
/
Count({<Status-={'REJECTED'}>}Items))<0.5"}>}

Aggr(NODISTINCT Count({<Status-={'REJECTED'},Code ={'AP'}>} Items)
/
Count({<Status-={'REJECTED'}>}Items), Items))

datashaw
New Contributor III

Re: Count the percentages if its dropped to certain level

Dear  expert,

 

its giving me the below screenshot instead of just a  % count