topic Trial run. in QlikView

Trial run.

Thu, 03 Oct 2013 09:12:43 GMT

Can someone email me both a QlikView pivot table and the source excel file that I then can replicate. This is because I hvae tried on numerous ocCan someone email me both a QlikView pivot table and the source excel file that I then can replicate. This is because I hvae tried on numerous occasions to upload an excel file and all I get in QlikView is a table that I cannot drill down on. Thanks.casions to upload an excel file and all I get in QlikView is a table that I cannot drill down on. Thanks.

Re: Trial run.

mazacini — Thu, 03 Oct 2013 20:13:05 GMT

Suggest you post sample of your Qlikview Table

Re: Trial run.

Josh_Good — Thu, 03 Oct 2013 22:30:00 GMT

I would recommend you take a minute to watch the following videos

Loading Excel Data into QlikView

Creating a Chart

One thing to highly regarding QlikView is you don't need to 'drill down' in the traditional BI sense but you make selections that filters the data.

If you would like to download sample data, there is a tutorial can is very helpful on the free training page that you can download. (scroll to the bottom).

http://www.qlik.com/us/services/training/free-training

Re: Trial run.

Fri, 04 Oct 2013 07:50:00 GMT

Fairly new to Qlik Community forum. How do I upload a sample of my Excel table on to this site? Thanks.

Re: Trial run.

mazacini — Fri, 04 Oct 2013 07:54:32 GMT

Can you attach an image?

Re: Trial run.

Fri, 04 Oct 2013 08:01:37 GMT

I tried (image insert/browse/open/insert image) and nothing happens and have to close image insert screen. Possibly doing something wrong or it doesnt accept excel files. The file is less the 2MB, the max image upload.

Re: Trial run.

mazacini — Fri, 04 Oct 2013 08:44:04 GMT

I created an image using Snipping Tool, saved the image, then attached it using the "Insert Image" icon

Re: Trial run.

jonathandienst — Fri, 04 Oct 2013 08:51:04 GMT

Click on Reply, and at the top right of the editor box, click "Use advanced editor". The file upload option is available there.

Jonathan

Re: Re: Trial run.

Fri, 04 Oct 2013 08:55:46 GMT

Thanks. Have now attached sample spreadsheet I want to use on QlikView. Can I do a drill down on this?

Re: Re: Trial run.

mazacini — Fri, 04 Oct 2013 10:09:27 GMT

I can't see attachment?

Joe

Re: Re: Re: Trial run.

Fri, 04 Oct 2013 10:19:37 GMT

How abiut now? I can see as an attachment on this response but can not actualy open it when double clicking on it. Also, I couldn't download snipping tool as site is restricted at work.

Re: Trial run.

Fri, 04 Oct 2013 10:19:52 GMT

Re: Trial run.

mazacini — Fri, 04 Oct 2013 12:04:07 GMT

My mistake. Looking in wrong place.

So, do you want to create a table in Qlikview same as the one in Excel?

Joe

Re: Trial run.

Fri, 04 Oct 2013 12:49:42 GMT

In QlikView I want to be able to click on say Excel cell reference C4 and be directed to cells C21:C24, those that make up the 74,167. And likewise for the cells in the top tables to drill down to the lower tables.

Re: Trial run.

mazacini — Fri, 04 Oct 2013 14:38:29 GMT

I think you would need a Straight Table with Set Analysis to replicate your Excel table in Qlikview, and I would suggest this would be difficult for someone new to Qlikview.

If you look in the properties tab for a Qlikview table, Qlikview uses the Dimensions tab to capture the Row and Column information used in Excel Pivot Table.

It uses the Expressions tab to capture the Value information used in Excel Pivot Table. Where you simply drag an Excel field to the Value row, in Qlikview you have to build the Expression, for instance Sum(YTD Income).

So, to have a QV pivot for, say, Income, you would need the following dimensions in your table(s)

Division (Operational, Corporate)

Department (Surgery, Medicine etc)

Income Type (Contracted, Non Contracted)

Income Sub Type (Elective, Non Elective etc)

and then an expression to give you the values you want.

Hope this helps