QlikView App Dev

[sam1508]

Hello all,

I would like to exclude Region filter from my expression but the below listed expression is not working. I have If condition for an aggregated dimension and trying to exclude Region filter. Please suggest.

= Count({<Region= >} Aggr (If ( Status = 'InProcess', Status <> 'Complete'), Commodities, Commodities))

Thanks.

[chrismarlow]

Hi,

I am not sure the IF formula here is doing what you think it is doing, for If statement would expect to see 3 parts (maybe 2 if value for false is null) and only 1st part would have a comparison ... if Status=InProcess then automatically Status<>Complete ...

Cheers,

Chris.

[sam1508]

Hello,

Yes, you are correct. It is not doing the desired behavior. I would like to write an expression in which I want to count 'InProcess' status for a Commodity if the status is not Completed. There may be additional records for the  3rd Status (Void) for that Commodity but I don't have to account for that . Can you please suggest the right expression. I wrote the below expression, it is not giving me the desired count and Region filter is also working which I don't want. 

= Count({<Region= >} Aggr (If ( BCet_Status = 'InProcess' and BCet_Status <>'Complete' or BCet_Status = 'Void' , BCet_Status ), B_Commodities, B_Commodities))

Thanks,

Sam

[anat]

aggr(count({<Region=,Status={'InProgress'}>}Commodities),Commodities)

[sam1508]

This is not working as expected. It won't check for other records for the same commodity with different Status. I would like to write an expression in which I want to count 'InProgress' status for a Commodity if the status is not Completed. There may be additional records for the  another Status (Void) for that Commodity but I don't have to account for that .

Also, it should count all the distinct InProgress commodities once if the condition satisfies. For below table, 

Comm1 doesn't have Complete Status so it should get counted as 1 for InProgress

Comm2 doesn't have InProgress status so it won't get counted.

Comm3 has Complete and InProgress both so we don't need to count as it is already Completed

Comm4 has InProgress so we need to count it as 1

So, total InProgress Status count for the below table is 2. Hope this example helps 

Commodities	Sub Commodity	Status
Comm1	SC1	Void
Comm1	SC2	InProgress
Comm1	SC3	InProgress
Comm2	SC1	Void
Comm2	SC2	Complete
Comm3	SC1	Complete
Comm3	SC2	InProgress
Comm4	SC1	InProgress

[Shepherd69]

---

@sam1508 wrote: MCDVOICE

Hello all,

I would like to exclude Region filter from my expression but the below listed expression is not working. I have If condition for an aggregated dimension and trying to exclude Region filter. Please suggest.

= Count({<Region= >} Aggr (If ( Status = 'InProcess', Status <> 'Complete'), Commodities, Commodities))

Thanks.

---

Modifiers are used to make additions or changes to a selection. Such modifications can be written in the set expression. A modifier consists of one or several field names, each followed by one or several selections that can be made in the field. Modifiers begin and end with angle brackets, <>.

[chrismarlow]

Hi,

Missed this, maybe;

Then just cancel your region selection as I think you got.

Cheers,

Chris.

[bennypal]

If your carrier allows it, you can view your APN settings in one of the following locations: Settings > Cellular > Cellular Data Options > Cellular Network. Settings > Mobile Data > Mobile Data Options > Mobile Data Network

• straight talk apn settings
• us cellular apn settings
• Bojangles corporate officers
• uber corporate office headquarters address
• how to factory reset a school Chromebook