topic Re: Showing Data Based on Selection in QlikView

Showing Data Based on Selection

Tue, 11 Oct 2011 17:02:27 GMT

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

Tue, 11 Oct 2011 17:34:00 GMT

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.

Tue, 11 Oct 2011 18:26:38 GMT

Thanks for your quick reply. It is working absolutely fine.... 🙂