Discussion board where members can get started with QlikView.
I want to show sales data based on selection. Example enlcosed for your reference.
Master Table is showing actual data I have in excel sheet.
TABLE I WANT is the table I want based on selection from LIST BOX named PLEASE SELECT.
Everything looks perfect... Now I want Product Name should be appeared as third column while I select ProductID.
i.e. While I select ProductID in PLEASE SELECT LIST BOX... below table should appear.
But if I select CustomeName or CustomerCountry, only two column should appear.
Is it possible...
Waiting for your kind reply...
Go to Solution.
You need to add the expression (ProductName) and put a condition in the Presentation tab for that column. If you use:
if(GetCurrentSelections() = 'Selection: ProductID', 1,0)
that should work for you. If it is 0 it will be invisible, if it is 1 it will show.
Thanks for your quick reply. It is working absolutely fine.... :-)