topic Set Expression to Include and Exclude in QlikView

Set Expression to Include and Exclude

Thu, 11 Apr 2013 13:58:31 GMT

This was the original formula I was using in a bar chart until I was told we needed to trim down the displayed system names:

=(count({$<history_status_name={'Resubmitted'}>}history_update_date)/count(add_date))

So I tried some set analysis wizard and it came out with the following formula, but of course QV didn't like it.

=count({$<system_name-={'Capacity Tool Addition','CN Release - Test Wafer','New Development','Production'}>}(count({$<history_status_name={'Resubmitted'}>}history_update_date)/count(add_date)))

I need to exclude the 4 system names first, and then use history status names of "Resubmitted" in the calculations. Any suggestions?

Re: Set Expression to Include and Exclude

Gysbert_Wassenaar — Thu, 11 Apr 2013 16:47:35 GMT

I'm afraid I don't understand your requirements. Does this do what you want:

=count({$<system_name-={'Capacity Tool Addition','CN Release - Test Wafer','New Development','Production'},history_status_name={'Resubmitted'}>}history_update_date)/count(add_date)))

Re: Set Expression to Include and Exclude

Thu, 11 Apr 2013 17:09:14 GMT

Try This

=count({1-$<system_name={'Capacity Tool Addition','CN Release - Test Wafer','New Development','Production'},history_status_name={'Resubmitted'}>}history_update_date)/count(add_date)))

Regards,

Nirmal.

Re: Set Expression to Include and Exclude

Thu, 11 Apr 2013 17:14:03 GMT

Yes it does, Gysbert! I had to remove two parantheses at the end and it still underlined everything after:

=count({$<system_name-=

with a squiggly red line, but it was exactly what I needed. This will help tremendously with the rest of my expressoins as well.