topic Re: Create Excel Spreadsheet-like objects in Qlikview in QlikView

Create Excel Spreadsheet-like objects in Qlikview

Mon, 15 Dec 2014 16:48:12 GMT

Hi all,

I will like to know whether it is possible to creating a spreadsheet-like objects in Qlikview? This is not importing Excel into Qlikview but creating an object that functions like an Excel spreadsheet within Qlikview. I have attached a simple spreadshee that I will like to create within Qlikview.

Please kindly advise.

Regars

Re: Create Excel Spreadsheet-like objects in Qlikview

prieper — Mon, 15 Dec 2014 21:15:49 GMT

You may look into the INPUTFIELD-functionality in QlikView, which delivers a very rudimentary kind of spreadsheet.

HTH Peter

Re: Create Excel Spreadsheet-like objects in Qlikview

Tue, 16 Dec 2014 10:50:24 GMT

Hi Peter,

Thank you, Inputfield function is a good solution.

The issue now is that formulas do not work in the cells i.e

=Count({$<[Sales.Current Month] = {'Telephone'}>} [Date])

or even

=Count ('Telephone')

Please how do I write formulas into Inputfiled cells?

Regards,

Re: Create Excel Spreadsheet-like objects in Qlikview

terezagr — Tue, 16 Dec 2014 10:53:52 GMT

I would use variables - in the load script you create a variable:

vSales ="Count({$<[Sales.Current Month] = {'Telephone'}>} [Date])"

in your table than call this variable.

Expressions: $(vSales)

Re: Create Excel Spreadsheet-like objects in Qlikview

Tue, 16 Dec 2014 11:12:00 GMT

Hi TerezaGr,

I tried both :

$(vSales)

=$(vSales)

But none worked..

Re: Create Excel Spreadsheet-like objects in Qlikview

terezagr — Tue, 16 Dec 2014 13:24:41 GMT

Well, you will have to have a chart (straight table), then an input box.

In the input box you will pick variable vSales from the list.

In the chart then in Expressions you will create an expressing where =$(vSales)

Whatever value you add into the input box this will be automatically shown in your table

Re: Create Excel Spreadsheet-like objects in Qlikview

Tue, 16 Dec 2014 14:09:01 GMT

Hi TerezaGr,

Thank you for your reply.

Following your instruction above, I have been able to progress further by using chart object, input box and expression.

The issue now is that the expression feeds throughout the Inputfield column - normally, this is fine. But for this task I will like each cell of the InputField to have its own expression.

I have attached a spreadsheet to show what I mean.

Regards,