Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%'),
' ')
Could you please post your app (you'll need to zip it as there's a bug on the Qlik Community site)?