how to modify the expression based on the Calculated Dimension?

Wed, 15 Apr 2015 08:39:54 GMT

Hi All,

Please help me solve the below issue.

I am creating a bar chart with 2 dimensions and one expression.

Dimensions are YearMonth and Site Name

Expression is count of field number.

in this chart, 2 more fields to be considered.

Fields Are 1) Description and 2) Receipt Issued?

condition is something like below:

If Description is Market withdrawal, then Site name should be appended with --Market withdrawal

If Site Name is 1, then Site name should be appended with --Receipt Sent

if none of the above conditions meet, then Site name should be appended with --Recall.

and the expression should count the Field Number, based on above dimension.

I tried this calculated Dimension:

=if([Description]='Market Withdrawal',[Site Name]& ' -' & 'Market Withdrawal', if([Receipt Issued?]='1',[Site Name]& ' -' & 'Receipt Sent',[Site Name] & ' -' & 'Recall'))

And below expression:

=if([Description]='Market Withdrawal',Count([Field Number]),

if([Receipt Issued?]='1',Count([Field Number]),Count([Field Number])))

But the count is not as expected.

if i try only below part of expression, count is proper

if([Description]='Market Withdrawal',Count([Field Number]),

if([Receipt Issued?]='1',Count([Field Number]))

Could someone please help me figure out what is going wrong here?

Can i avoid this calculated dimension and manipulate the expression to satisfy the requirement?

Thanks & regards

Jyothi

Re: how to modify the expression based on the Calculated Dimension?

Thu, 16 Apr 2015 09:28:48 GMT

just the Count([Field Number])) in the expression did the trick.

topic Re: how to modify the expression based on the Calculated Dimension? in QlikView

how to modify the expression based on the Calculated Dimension?

Re: how to modify the expression based on the Calculated Dimension?