Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Showing Data Based on Selection

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.

ProductIDProductNameTOTAL
PRD 001FILES23000
PRD 002MOBILE85000
PRD 003NOTEBOOK11500
TOTAL119500


But if I select CustomeName or CustomerCountry, only two column should appear.

Is it possible...

Waiting for your kind reply...

1 Solution

Accepted Solutions
Not applicable

Re: Showing Data Based on Selection

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. 

2 Replies
Not applicable

Re: Showing Data Based on Selection

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. 

Not applicable

Re: Showing Data Based on Selection

Thanks for your quick reply. It is working absolutely fine.... :-)