topic Re: how to create a table without making any changes in data manager and data load editor ? in App Development

how to create a table without making any changes in data manager and data load editor ?

Iras — Sat, 16 Nov 2024 04:12:25 GMT

Dear all,

I would like to create a small table i.e. with two row values and one column i.e. [ HR, EUR] without making any changes in the data manager and data load editor. The reason is to use them in variable input chart as buttons for filtering out the charts.

I have used if conditions in all the graphs based on this two values i.e. If( Table ='HR'; condition expression 01, condition expression 02).

Is it possible to create a table using variable or function inside the filter ? If so pls share.

Regards

Praneeth

Re: how to create a table without making any changes in data manager and data load editor ?

CurtDaughtry — Mon, 04 Nov 2019 15:22:45 GMT

I'm not sure I understand your question.

Will you elaborate?

You could use valuelist() to create a custom dimension that you then identify with each expression. Does that help?

Re: how to create a table without making any changes in data manager and data load editor ?

Iras — Mon, 04 Nov 2019 15:53:10 GMT

I would like to create a filter which has this two value. But I don't want to add more data in the data manager or in data load editor.

Type

EUR

based on selection on this filter I had written if expression in my charts i.e. ( If( Type= ' HR', Expression 1, Expression 2)

But I am unable to create this type of list in my charts.

How to do so ?

Re: how to create a table without making any changes in data manager and data load editor ?

Mauritz_SA — Mon, 04 Nov 2019 16:20:23 GMT

Hi there

If you want to use a normal filter then I don't think ValueList will work - it is not a field that can be selected and only applicable to the object in which it is created. It is explained by Jonty in this thread. As he mentions, you can add a simple island table with a Type Column and two values for HR and EUR. For example, just add:

FilterTable:

LOAD * INLINE [

Type

EUR

];

You can then reference the Type field in your expressions and even make it an Always one selected value field.

If you can't do this then I suggest that you create a variable and use the Variable input extension in the standard Qlik Dashboard buttons to assign one of the two predefined values (HR or EUR) to it.

Hope this helps.

Mauritz

Re: how to create a table without making any changes in data manager and data load editor ?

CurtDaughtry — Mon, 04 Nov 2019 16:23:58 GMT

Agree with @Mauritz_SA

Re: how to create a table without making any changes in data manager and data load editor ?

Iras — Mon, 04 Nov 2019 18:44:50 GMT

Thanks you for your reply..

I can't make any changes in data load editor or data manager . Is it possible to write the same below code in the chart areas. or in the edit sheet inside the chart expression area ?

FilterTable:

LOAD * INLINE [

Type

EUR

];

could you please elborate bit more about how to create in Variable input extension ?

Re: how to create a table without making any changes in data manager and data load editor ?

Mauritz_SA — Tue, 05 Nov 2019 06:31:41 GMT

Hi there

No, you can't use an inline table in the front end. To go the variable option, you need to do the following:

Create a variable, let's call it vType.
Go to Custom Objects (below Charts on the left of the screen).
Go to Qlik Dashboard bundle
Go to Variable Input and drag it onto the screen
Under the variable tab on the right (when the Variable input object it selected), go to Variable and select vType under Name.
Under Show as, select Buttons.
Go to the Values tab and select Fixed.
Add an Alternative with Value 'EUR' and Label EUR.
Add another Alternative with Value 'HR' and Label HR.

In an expression, you can now write something like IF($(vType)='HR',Sum(Sales),Ave(Sales))

Hope this helps.

Regards,

Mauritz

Re: how to create a table without making any changes in data manager and data load editor ?

Iras — Tue, 05 Nov 2019 08:25:53 GMT

Thanks a lot Mauritz_SA. It worked.. But when Nothing is selected the KPI value is showing as "-". How can I make sure that one value is always selected ?

Re: how to create a table without making any changes in data manager and data load editor ?

Mauritz_SA — Tue, 05 Nov 2019 08:47:39 GMT

Assign a value to the variable description like 'EUR' in step 1.

Just go the variable and update the description 👍.

Re: how to create a table without making any changes in data manager and data load editor ?

Iras — Tue, 05 Nov 2019 08:55:40 GMT

Thanks alot..

Re: how to create a table without making any changes in data manager and data load editor ?

Mauritz_SA — Tue, 05 Nov 2019 09:03:14 GMT

You're welcome - glad I could help!