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: 
curiousfellow
Specialist
Specialist

"Or"in set analysis

i have an expression like this :

=count({<week_subscription= {"<$(currentweek)"},week_subscription_canceled= {">=$(currentweek)"} + subscription_canceled= {$(=0)}  >}employee)

The "+" sign should be read as "OR"

I don't get any results, when I use only one part of the OR statement I do get results so there must be something wrong  in the or statement.

Any help ?

I want to compare subscriptions per year

Thanks in advance

1 Reply
sunny_talwar

May be this:

=Count({<week_subscription = {"<$(currentweek)"}, week_subscription_canceled = {">=$(currentweek)"}> +<subscription_canceled = {$(=0)}>} employee)