It sounds like your calculated field is incomplete. What is the formula you are using now? When I create a dynamic set, my calculated field follows the following:
If (enter the requirement) then 1 else 0 end
And then I filter on 1. Mine always works.
Thanks for the response, although I remain a bit lost. Here is what I have:
Parameter with 3 string choices
Calculated field that can convert string choice to 1 or 0
I am having a problem connecting that calculated field to a specific set
that I am using as a filter. When I write any if or case statement I get
that I cannot use the set because it is a boolean.
If parameter =1 THEN end or
Case parameter WHEN 1 THEN end
On Wed, Aug 5, 2015 at 5:56 PM Ailsa Zheng <
Can you upload a sample workbook please? This would help a lot!
Will try and get this to you in the next 24 hours. Thank you
On Thu, Aug 6, 2015 at 2:19 PM Ailsa Zheng <
I have put together a rough workbook with the three sets a parameter and calculated field that I would like to use as the filter. Any of the measures can be used. Again thank you for the help.
Book1.twbx 1.8 MB
I found a workaround for your problem:
I created 3 measures: CHF Match, COPD Match, and Sepsis Match.
If [CHF] then 1 end
If [COPD] then 1 end
If [Sepsis] then 1 end
And then for the Set Filter:
Case [Set Parameter] WHEN "CHF" THEN [CHF Match]
WHEN "COPD" THEN [COPD Match]
WHEN "Sepsis" THEN [Sepsis Match]
I put the Set Filter in the filter. Please see attached. I put the revised version on worksheet #2.
charles.twbx 1.8 MB
Thank you so much for your help and persistence.