topic Re: Expression error in QlikView

Expression error

alec1982 — Mon, 17 Sep 2012 14:16:10 GMT

Hi,

Not sure why this expression is giving me error.

Even I have all the right field and the right selection

Sum({<[Year of Expense] = {$(varPlReportingYear)},

[Expense Type (annual)] = {"*Rent*"} or GetFieldSelections(_ShowRentFlag)=1

>} [Amount of Expense (USD-annual)])

I apprciate any help!

Re: Expression error

jvitantonio — Mon, 17 Sep 2012 14:27:21 GMT

Can you be more specific please? Can you attach a screenshot with your formula or paste it here?

Re: Expression error

whiteline — Mon, 17 Sep 2012 14:38:23 GMT

Because of this:

Sum({<[Year of Expense] = {$(varPlReportingYear)}, [Expense Type (annual)] = {"*Rent*"} or GetFieldSelections(_ShowRentFlag)=1>} [Amount of Expense (USD-annual)])

What do you want to calcualte?

Re: Expression error

Mon, 17 Sep 2012 14:38:58 GMT

You are not using an IF condition, then how come you are using an OR operator in your expression?

I don't think you can use a OR operator in SET Analysis.

Re: Expression error

alec1982 — Mon, 17 Sep 2012 14:43:44 GMT

Hi,

Thank you for the reply,

The expression in different way is :

Sum(if ( ((Index([Expense Type (annual)], 'Rent') = 0) or GetFieldSelections(_ShowRentFlag)=1)

and ([Year of Expense] = $(varPlReportingYear))

, [Amount of Expense (USD-annual)]

)

This doesn't give me error but It doesn't give me the right nr.

Anyway, I can write the expression differently than this?

Thxs,

Re: Expression error

alec1982 — Mon, 17 Sep 2012 14:59:54 GMT

The Get field selection is a toggle that include/ exclude one of the dimension values.

The chat that I have is a bar chart that show expenses by expense type such as rent, parking,..

the toggle is to include/ exclude the rent bar.

Thxs,

Re: Expression error

Mon, 17 Sep 2012 15:13:17 GMT

I would suggest you to remove the check in expression and include it in Dimension.

Make it a calculated dimension with a 'IF' clause and make it NULL in case the flag is selected.

Re: Expression error

alec1982 — Mon, 17 Sep 2012 15:25:46 GMT

Thxs for the reply,

may you please give me more details or do you have any sample.

Thxs,

Re: Expression error

Mon, 17 Sep 2012 15:36:19 GMT

Very simple example is attached.

If you are looking for a different approach, feel free to attach a dummy dashboard to work on.

Re: Expression error

alec1982 — Mon, 17 Sep 2012 18:52:22 GMT

Hi,

Thank you for the sample. but it didnt fix my issue

I have exported the table into an excal file and created a new qvw and loaded the data and copied the same chart in it.

In the new QVW everything is loading correctly! and the numbers are correct.

but on the requiered one, Numbers are not correct!

Any idea on what could be effecting the chart to not calculate correctly?

Attached is the new qvw.

Thxs

Re: Expression error

Mon, 17 Sep 2012 19:51:58 GMT

I see only 2 objects in the QVW (2 Table objects) but NO chart.

Can you please re-attach the file with the chart which is not functioning as required?

Re: Expression error

alec1982 — Mon, 17 Sep 2012 20:24:39 GMT

Sorry about that, here is the qvw.

Thxs,

Re: Expression error

alec1982 — Mon, 17 Sep 2012 20:33:52 GMT

On this qvw everything is working normally but when i add it to the main dashboard, it gives me highers even I am using the same fields on the attached qvw.

Thxs for your help.

Alec

Re: Expression error

Mon, 17 Sep 2012 20:48:49 GMT

Well if you have got this qvw working then I am not sure what data model is affecting when you merge this to the main Dashboard.

However, I have attached the method in which you can control the displaying Dimensions based on the toggle.

Hope this helps.

Re: Expression error

alec1982 — Mon, 17 Sep 2012 21:39:07 GMT

hi,

The data model is correct and have no issues, somehow qlikview responses to the expression in a wierd way sometimes.

the new qvw expression and dim that you sent me worked just fine on the main dashboard.

Thxs for your help.