topic Re: Error In Set Analysis Expression - Syntax Error? Unable To Determine in QlikView

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

pnn44794 — Sat, 16 Nov 2024 04:46:43 GMT

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.

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

sunny_talwar — Fri, 11 Jan 2019 19:03:06 GMT

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

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

pnn44794 — Fri, 11 Oct 2019 20:34:28 GMT

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?

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

sunny_talwar — Fri, 11 Jan 2019 19:28:21 GMT

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

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

pnn44794 — Fri, 11 Jan 2019 19:59:56 GMT

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?

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

sunny_talwar — Fri, 11 Jan 2019 20:02:37 GMT

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?

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

pnn44794 — Fri, 11 Jan 2019 22:24:18 GMT

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.

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

pnn44794 — Sat, 12 Jan 2019 22:49:56 GMT

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.