topic Re: Table box calculation condition in QlikView

Table box calculation condition

Tue, 19 Nov 2013 09:18:31 GMT

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

I am using the following condition in the calculation condition.

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!!

Re: Table box calculation condition

swuehl — Tue, 19 Nov 2013 09:24:40 GMT

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?

Re: Table box calculation condition

Tue, 19 Nov 2013 09:31:42 GMT

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

Re: Table box calculation condition

kaushiknsolanki — Tue, 19 Nov 2013 09:35:56 GMT

Hi,

Kindly tell us what expression you have written.

Regards,

Kaushik Solanki

Re: Table box calculation condition

Tue, 19 Nov 2013 09:37:30 GMT

Re: Table box calculation condition

kaushiknsolanki — Tue, 19 Nov 2013 09:39:34 GMT

Dear Poornima,

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

Regards,

Kaushik Solanki

Re: Table box calculation condition

Tue, 19 Nov 2013 10:08:18 GMT

i dont have any expression in my table box.

i load all the fields from a qvd.

Re: Table box calculation condition

kaushiknsolanki — Tue, 19 Nov 2013 10:11:57 GMT

HI,

Paste your application.

Regards,

Kaushik Solanki

Re: Table box calculation condition

Anonymous — Tue, 19 Nov 2013 10:25:41 GMT

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.

Re: Re: Table box calculation condition

Tue, 19 Nov 2013 11:07:04 GMT

PFA.

Re: Re: Table box calculation condition

swuehl — Tue, 19 Nov 2013 11:13:19 GMT

First of all, you are using a different expression for your calculation condition then stated.

If you use

GetSelectedCount(YEAR)=1 and GetSelectedCount(COMP)=1

You only get a table when you select a single YEAR and a single COMP.

You will still see HMA in the column DT_COM, because your table you made selections in and your dashboard table are only connected by date, so your selection in field COMP does not necessarily be reflected in field DT_COM (that's what I meant wiht different fields used in different tables, remember my first answer?)

Re: Re: Table box calculation condition

Tue, 19 Nov 2013 11:26:12 GMT

how to avoid other company data while i select a company here?

Re: Re: Table box calculation condition

swuehl — Tue, 19 Nov 2013 11:38:37 GMT

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

Select in this list box.

Re: Table box calculation condition

Anonymous — Tue, 19 Nov 2013 11:39:03 GMT

how could this be possible when you select Year 2013 and company cocky then you youself

is filtering entire data model and there should not be any data other the for 2013 and for comapny cocky

just check your data model and please paste a screen shot of your data model and table box.

i do not feel there is need of any function as you used this is not needed when

anant

Re: Re: Table box calculation condition

Tue, 19 Nov 2013 11:41:54 GMT

Sooper !!

it worked!:)

Re: Re: Table box calculation condition

Anonymous — Tue, 19 Nov 2013 14:02:15 GMT

Hi,

Your data model is wrong.

You have a check your data model and organize it.