Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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!!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

Select in this list box.

View solution in original post

15 Replies
swuehl
MVP
MVP

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
Author

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Kindly  tell us what expression you have written.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Error.jpg

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Dear Poornima,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

i dont have any expression in my table box.

i load all the fields from a qvd.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

     Paste your application.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

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
Author

PFA.