Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Wrong work of complex Set Analisys in Count function?

I need to do a complex set analisys in my count function, but as you can see in attachment - Count works wrong with the complex set analisys, while Concat works perfect.

How this issue can be solved? Or maybe I have mistakes in my Set Analisys?

4 Replies
Not applicable
Author

Try without using distinct in count function... But don't ask me why.

Not applicable
Author

I need it to be distinct 😞 for now I have a solution:

=SubStringCount(concat({$<F1={">=2"}>*($<F2={1}>+$<F3={1}>)} distinct F1,'-'),'-')+rangemin(1,len(concat({$<F1={">=2"}>*($<F2={1}>+$<F3={1}>)} distinct F1,'-')))

thow it looks like going to Washington from NY through Moscow...


Not applicable
Author

Going back to your firsts expressions, did you try to make a table? If you put the expression ant then one, two or the three dimensions (F1,F2,F3), the count function works as it should. However, if you leave the table without dimensions it works wrong... Tongue Tied

What we are missing must be something stupid...

pover
Partner - Master
Partner - Master

Try the following formula. It seemed to work for me in you example file.

count({$<F1={">=2"} * (P({1<F2={1}>}) + P({1<F3={1}>}))>} distinct F1)

Regards.