Discussion Board for collaboration related to QlikView App Development.
I have two tables in my QV applications;
and a Dimension
In the listbox I use I only want to show the products with a value in the facttable.
I have tried to use an expression in the general tab in the listbox like;
But this doesn't work. Can anyone help me out here, thnx in advance.
Go to Solution.
if you insist of calc it in the frontend: you have been very close. You need to add the aggr()-function within your listbox-expression:
You can change the data model.
Create a alise field of ProductNr in Fact Table. Like
ProductNr as Product,
Now you can use Product in listbox. this will only show you the values from fact table.
That's a good one! Is this the only solution, or is it also possible to do this in the front-end?
Yes there is but in that case it will not be a list box, It will be a chart.
Use the same chart you have created. Just convert it into straight table. Then go to properties -> presentation -> click on the expression and click hide column.