topic Re: tableau with updatable string fields in QlikView

tableau with updatable string fields

Tue, 24 Sep 2013 13:47:13 GMT

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

Re: tableau with updatable string fields

Wed, 25 Sep 2013 08:56:47 GMT

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

Re: tableau with updatable string fields

armandfrigo — Wed, 25 Sep 2013 09:19:13 GMT

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

Re: Re: tableau with updatable string fields

tresB — Wed, 25 Sep 2013 09:32:05 GMT

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

Re: tableau with updatable string fields

Wed, 25 Sep 2013 09:33:22 GMT

Can you post a sample of your source data here?

Re: tableau with updatable string fields

Wed, 25 Sep 2013 09:33:43 GMT

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

Re: tableau with updatable string fields

Wed, 25 Sep 2013 13:12:31 GMT

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>