Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
kristen_qlik_noob
New Contributor

Formula for percentage of numbers equal to 1 not working in Crosstable - Help please

Creating Crosstable syntax:

crosstable (Product_Solutions,Monthly_Trend, 1)
LOAD
wave,
q18_a,
q18_b,
q19_a,
q19_b,
q19_c,
q19_d,
q19_e,
q19_f,
q19_g,
q19_h,
q19_i,
q19_j
FROM [lib://AttachedFiles/Brand_QlikSense_New.csv]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

 

Here is a formula I am trying that will only count numbers if the N is over 100 and if the response is equal to 1.  Can anyone point out what's wrong with the formula? 

If (Count(Product_Solutions) >=100,
Num(Count({<Product_Solutions = {"=1"}>} Product_Solutions) /Count(Product_Solutions),'0%'),
' ')

3 Replies
kristen_qlik_noob
New Contributor

Re: Formula for percentage of numbers equal to 1 not working in Crosstable - Help please

Still stuck on this formula if anyone can help. It appears to just be dividing the numbers equally across the columns?
rbartley
Valued Contributor

Re: Formula for percentage of numbers equal to 1 not working in Crosstable - Help please

Could you please post your app (you'll need to zip it as there's a bug on the Qlik Community site)?

kristen_qlik_noob
New Contributor

Re: Formula for percentage of numbers equal to 1 not working in Crosstable - Help please

 

 

 

Community Browser