Create Excel Spreadsheet-like objects in Qlikview

[#1]

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

[prieper]

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

HTH Peter

[#3]

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,

[terezagr]

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)

[#5]

Hi TerezaGr,

I tried both :

$(vSales)

=$(vSales)

But none worked..

[terezagr]

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

[#7]

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,