Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
rittermd
Not applicable

Create a filter based on excel columns

My data source in an excel spreadsheet.  Each row is a Branch.  Each column is a year (2010 - 2016).

I have loaded the data into a table and I want the user to be able to pick a year and limit the data that is visible.  I am not sure if or how I can do this with excel. 

                 2010   2011     2012  2013   2014  etc.

Branch A     100     200     300     500     700

1 Solution

Accepted Solutions
OmarBenSalem
Not applicable

Re: Create a filter based on excel columns

You use crosstable:

Crosstable (Year, measure, 1) LOAD * INLINE [

Branch,   2010,   2011,     2012,  2013,   2014 

Branch A, 100 ,    200,     300,     500,     700

Branch B, 200 ,    400,     300,     700,     900

];

result:

Capture.PNG

1 Reply
OmarBenSalem
Not applicable

Re: Create a filter based on excel columns

You use crosstable:

Crosstable (Year, measure, 1) LOAD * INLINE [

Branch,   2010,   2011,     2012,  2013,   2014 

Branch A, 100 ,    200,     300,     500,     700

Branch B, 200 ,    400,     300,     700,     900

];

result:

Capture.PNG