Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pnn44794
Partner - Specialist
Partner - Specialist

Error In Set Analysis Expression - Syntax Error? Unable To Determine

Hello:

I'm sure I'm missing something simple in the following expression, but I would appreciate another set of eyes taking a look to see what may be wrong.

 

The expression editor simply says "Error in expression" and puts a red squiggly line under the last parentheses.  All the parentheses seem to match up.

As always, any and all help is appreciated.  Thanks in advance.

 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Try this

Num(Count({<
[Service Ordered] *= {'Virtual Server Infrastructure (VSI)', 'VSI ICP2'},
Forecast_Product_Base_C *= {'VSI Bronze Base'},
[Approval Completed Quarter] *= {'2019-Q1'}>}
[Host Name]), '#,##0')

View solution in original post

7 Replies
sunny_talwar

Try this

Num(Count({<
[Service Ordered] *= {'Virtual Server Infrastructure (VSI)', 'VSI ICP2'},
Forecast_Product_Base_C *= {'VSI Bronze Base'},
[Approval Completed Quarter] *= {'2019-Q1'}>}
[Host Name]), '#,##0')
pnn44794
Partner - Specialist
Partner - Specialist
Author

Hello Sunny:

Thanks for the quick reply.  I appreciate it.  Yes, you're solution works.  So, would I be right to assume the If isn't needed because I'm being specific about what to count?

sunny_talwar

If Product is your dimension, you wouldn't need if statement....

pnn44794
Partner - Specialist
Partner - Specialist
Author

Product is the dimension label.  Forecast_Product_Base_C is the actual dimension name for that column.  If I don't need the IF statement, what would the set analysis look like?

sunny_talwar

I am not sure I understand your data... would you be able to share some raw data and the output you expect from it in an Excel file?

pnn44794
Partner - Specialist
Partner - Specialist
Author

I'm having a problem with my data model at the moment.  Once I get that fixed, I'll provide some sample data and sample output.  I appreciate your patience.

pnn44794
Partner - Specialist
Partner - Specialist
Author

Hello Sunny:

I'm still having some data problems, but your initial answer was correct and I will mark it as such.  I'll start another thread if needed for my newest problem.  Thank you for your assistance.  It's appreciated.