tableau with updatable string fields

[#1]

hi everybody,

sorry for bothering you.. but i am stuck on something which seems simple..

In SQL, we can do something like SELECT AVG(FIELD1), MAX(FIELD1) WHERE CRITERIUM=’SOMETHING’

Here criterium is a string for which we compute the aggregates.

Now imagine I want to create a tableau where the user can input different string criteria in different rows, to obtain the corresponding aggregates in the next columns. Something like that :

Criterium Avg(field1)         Max(field1)

AAA      102                     120

BBB      115                     135

CCC      98                        112

…

In this tableau, the user could type AAA in the first column and get the aggregate values in colums 2 and 3. Then he could type BBB in a second row and get the corresponding aggregates. And so on.

How could I manage to do this ?

thankk you for everything

[#2]

Waiting for your answer... if you need any detail, i will answer asap...

[armandfrigo]

Hi Yoel,

QlikView is not really a solution where we can input data. QlikView can do what-if analysis or budget forecasting to some extend, but this is limited to entering numbers.

I understand it might seem simple in SQL, QlikView can actually do the same as what you describe.

However, if you want to input data, in any SQL database or in QlikView this is where you will struggle.

I cannot think of any way to achieve this with a table object.

If you have a limited number of values, you could design a screen with variables and individual text objects to display the aggregate results:

Variable A as input box     |      Text object to show Avg(Variable 1)     | Text object to show Max(Variable 1)

KT Labs have created a data entry extension for QlikView, but I am not sure if it will support strings. As far as I know about their solution, this is designed for Finance Controllers who work on budget figures (numbers).

KliqPlan smart data-entry for QlikView

I hope this helps.

Best regards,

Armand

[tresesco]

There would be other ways like using valuelist(). But one simple way you might want to try like attached sample.

[#5]

Can you post a sample of your source data here?

[#6]

Hi,

if the data already loaded:

A listBox with the Criterium field could be the solution.

I fyou need to reload:

store the criterium into a variable

modify your script to take into account this variable

create a button to reload the data

Fabrice

[#7]

Est-ce que je peux t’appeler 5 min stp ?

De : Armand Frigo

Envoyé : mercredi 25 septembre 2013 11:35

À : TORDJMAN Yoel

Objet : Re: - tableau with updatable string fields

QlikCommunity<http://community.qlik.com/>

tableau with updatable string fields

reply from Armand Frigo<http://community.qlik.com/people/afg?et=watches.email.thread> in App Development - View the full discussion<http://community.qlik.com/message/396837?et=watches.email.thread#396837>