topic Calculated Condition in QlikView

Calculated Condition

hopkinsc — Mon, 29 Nov 2010 11:34:28 GMT

hi, i am trying to write a calculated condition. I want the user to select a few specific fields before displaying the results.
What i want is....
The user to select 1 of 4 fields AND another 1 of 2 fields.....

my fields are: [Retail Group], [BDA Name], [Area Manager Name], Customer, Cal_Week, StoreDate

Eg,
The user is to select either:
[Retail Group], [BDA Name], [Area Manager Name], Customer

AND either
Cal_Week, StoreDate

I have tried using the following,

GetSelectedCount ([Retail Group]) > 0 or GetSelectedCount ([BDA Name]) > 0 or GetSelectedCount ([Area Manager Name]) > 0 or GetSelectedCount (Customer) > 0 and GetSelectedCount (Cal_Week) > 0

This works fine if i only have 1 field at the end, (Cal_Week or StoreDate)
Can someone help please?

AND either

Cal_Week, StoreDate

Calculated Condition

jonathandienst — Mon, 29 Nov 2010 11:49:21 GMT

Perhaps this...

GetSelectedCount ([Retail Group]) > 0 or GetSelectedCount ([BDA Name]) > 0 or GetSelectedCount ([Area Manager Name]) > 0 or GetSelectedCount (Customer) > 0 and (GetSelectedCount (Cal_Week) > 0 or GetSelectedCount(StoreDate))

Hope that helps

Jonathan

Calculated Condition

jonathandienst — Mon, 29 Nov 2010 11:50:22 GMT

Oops - should read this way:

(GetSelectedCount ([Retail Group]) > 0 or GetSelectedCount ([BDA Name]) > 0 or GetSelectedCount ([Area Manager Name]) > 0 or GetSelectedCount (Customer) > 0) and (GetSelectedCount (Cal_Week) > 0 or GetSelectedCount(StoreDate))

Jonathan

Calculated Condition

hopkinsc — Mon, 29 Nov 2010 12:10:57 GMT

Thanks Jonathan, that worked great.

I'm sure i tried that though and it didn't work.....

Working now though.

thanks