Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Create a list box for D_COMP (the field you are actually showing in the table box, right?).
Select in this list box.
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?
Usually this should work, can you post a sample app with small data?
Hi,
Kindly tell us what expression you have written.
Regards,
Kaushik Solanki
Dear Poornima,
This is for the calculation condition, but i am asking about the actual expression to show the data.
Regards,
Kaushik Solanki
i dont have any expression in my table box.
i load all the fields from a qvd.
HI,
Paste your application.
Regards,
Kaushik Solanki
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.
PFA.