Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Table box calculation condition

I am using a Table box to select data based on the two fields : Year and Company.

Error.jpg

I am using the following condition in the calculation condition.

Error.jpg

But when i select 2013 year and COKY company,all company data is getting populated in the table box.

Am i missing anything in the condition above.

Please help!!

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Re: Table box calculation condition

Create a list box for D_COMP (the field you are actually showing in the table box, right?).

Select in this list box.

15 Replies
MVP
MVP

Re: Table box calculation condition

Could you attach a small sample application that demonstrates this issue?

Are you using several Company fields like COMP and Company in separated tables, and maybe mixed these in your table box field and calculation condition?

Not applicable

Re: Table box calculation condition

Usually this should work, can you post a sample app with small data?

Re: Table box calculation condition

Hi,

    Kindly  tell us what expression you have written.

Regards,

Kaushik Solanki

Not applicable

Re: Table box calculation condition

Error.jpg

Re: Table box calculation condition

Dear Poornima,

     This is for the calculation condition, but i am asking about the actual expression to show the data.

Regards,

Kaushik Solanki

Not applicable

Re: Table box calculation condition

i dont have any expression in my table box.

i load all the fields from a qvd.

Re: Table box calculation condition

HI,

     Paste your application.

Regards,

Kaushik Solanki

sbobbyraj
Contributor III

Re: Table box calculation condition

Hi,

As there is no expression, your condition is useless. In fact you are asking QlikView to calcul something if a condition is true but there is no calcul...

You should use your expression to show the complete table.

So that your table will no been shown instead the expression in your condition is true.

Not applicable

Re: Re: Table box calculation condition

PFA.

Community Browser