topic Re: Set Analysis Troubleshooting in QlikView

Set Analysis Troubleshooting

Mon, 08 Sep 2014 20:49:17 GMT

Hello!

I'm trying to create a chart that reflects the activity of a sales group (comprised of Persons A, B, C) but updates to reflect individuals' activities based on the selection. But when I make a selection, the chart does not change and continues to reflect Meetings for A, B, and C. Can someone help? Much appreciated!

count({$<CRM_USER_NAME={'Person A', 'Person B', 'Person C'},TYPE ={'MEETING'}>} %Fact_Key)

Re: Set Analysis Troubleshooting

Mon, 08 Sep 2014 20:54:48 GMT

Duplicate the column on backend use one for set analysis another one for selection. Let me know if it works.

Thank you

Suraj

Re: Set Analysis Troubleshooting

Mon, 08 Sep 2014 20:57:28 GMT

Do you know a way to solve the issue by fixing the expression, instead of touching the backend?

Re: Set Analysis Troubleshooting

Mon, 08 Sep 2014 21:01:51 GMT

The only way is without using the set analysis. Because the main purpose of set analysis is that the selections of field in set analysis doesn't impact the calculation.If you want only in expression I would use if statement: if(CRM_USER_NAME={'Person A', 'Person B', 'Person C'}, Count({<TYPE ={'MEETING'}>} %Fact_Key).

Thank you

Suraj

Re: Set Analysis Troubleshooting

JonnyPoole — Mon, 08 Sep 2014 21:03:18 GMT

Would you like to see Person A, B and C of type meeting by default, but if you make additional filter to show say just Person B, do you want it show only Person B in the chart ?

Please be very precise in what you are looking to achieve. You may want the intersection of canned filters and dynamic filters which is possible in SET ANALYSIS. You could also do an IF statement based on whether 1 or more fields have been selected using getselectedcount(fieldname) for example.

Re: Set Analysis Troubleshooting

Mon, 08 Sep 2014 21:07:35 GMT

Yes, I am looking for precisely what you said.

Would you please expand on how to execute either of your suggestions?

Re: Set Analysis Troubleshooting

Mon, 08 Sep 2014 21:30:02 GMT

Try this IF(MATCH(CRM_USER_NAME, 'Person A','Person B', 'Person C'), Count({<TYPE ={'MEETING'}>} %Fact_Key))

Thanks

Suraj

Re: Set Analysis Troubleshooting

JonnyPoole — Mon, 08 Sep 2014 21:36:10 GMT

For the SET ANALYSIS try using *=. If you select Person A the chart will only show person A and type=meeting, If you select Person D, the chart will show nothing. Basically this returns the records that belong to the current selections AND the Selections in the modifier. So they can further reduce what is in the SET MODIFIER.

count({$<CRM_USER_NAME*={'Person A', 'Person B', 'Person C'},TYPE *={'MEETING'}>} %Fact_Key)

Is this what you want or do you want to remove the SET MODIFIER completely if a user selects a different CRM_USER_NAME or TYPE ?

Re: Set Analysis Troubleshooting

Mon, 08 Sep 2014 21:47:43 GMT

Nice to know about this. I didn't knew about *=.
Thanks Poole.

Thanks

Suraj

Re: Set Analysis Troubleshooting

Wed, 10 Sep 2014 13:45:44 GMT

Thank you Johnathan, this is what I want. But it seems there is a syntax error. All I've done is replace the user names with actual values... can't figure out what's wrong. Any suggestions?

Re: Set Analysis Troubleshooting

JonnyPoole — Wed, 10 Sep 2014 13:48:22 GMT

Can you post your syntax/expression?

Re: Set Analysis Troubleshooting

Wed, 10 Sep 2014 13:55:30 GMT

count({$<CRM_USER_NAME*={'LAST1, FIRST1','LAST2, FIRST2'},SLX_TYPE_DESCRIPTION *={'MEETING'}>}%Fact_Key)

Re: Set Analysis Troubleshooting

jonathandienst — Wed, 10 Sep 2014 13:59:03 GMT

If by syntax error, you mean the wavy red underlining under the *=, you can ignore that, it is a bug in the syntax checker.Your syntax looks OK, but I don't think you need the *= on the second clause of your set expression.

HTH

Jonathan

Re: Set Analysis Troubleshooting

Wed, 10 Sep 2014 14:12:28 GMT

You're right about the bug! thank you.

Re: Set Analysis Troubleshooting

Wed, 10 Sep 2014 14:15:23 GMT

Thank you Suraj! but for my needs this doesn't work because I want to display the total count for Person A, B and C when no CRM_USER_NAME is selected.