Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pnn44794
Partner
Partner

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')

View solution in original post

pnn44794
Partner
Partner
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
Partner
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
Partner
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
Partner
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.