topic Re: Bypass problem in QlikView

Bypass problem

Mon, 06 Jan 2014 17:57:52 GMT

Dear All,

I want to bypass Market field but not able to bypass...

My expression is ::

If(Flag1 = 'SS',

(Sum({<[HF NAME] = {'TURNOVER'},Market1=>}[Amount])),

If(Flag1 = 'CC',

(Sum({<[HF] = {'TURNOVER'},Market1=>}[Amount in local cur.]))

- Sum({<[HF NAME]={'DEDUCTION THIRD'},Market1=>}[Amount in local cur.])

- (Sum({<[HFM NAME]={'DIRECT COST'},Market1=>}[Amount in local cur.])* -1)))

Plz tell me is there is any fault in the expression ...??

Nicole-Smith — Mon, 06 Jan 2014 18:03:42 GMT

Where do you have this? Is it a dimension? Expression? Load Script?

If it's a dimension, you need aggr() in order to use an aggregation function.

If it's in the load script, you can't use set analysis.

Clever_Anjos — Mon, 06 Jan 2014 18:06:41 GMT

Is your expression tab showing any errors?

Mon, 06 Jan 2014 18:13:07 GMT

Its my expression ...and there is no error occurs but market is not bypass by this...

Nicole-Smith — Mon, 06 Jan 2014 18:14:02 GMT

It should be. I don't see anything wrong with your expression. Can you please post a sample .qvw?