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

[Iras]

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

[CurtDaughtry]

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?

[Iras]

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

HR

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 ? 

[Mauritz_SA]

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

HR

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

[CurtDaughtry]

Agree with @Mauritz_SA 

[Iras]

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

HR

EUR

];

or 

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

[Mauritz_SA · Accepted solution]

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:

1. Create a variable, let's call it vType.
2. Go to Custom Objects (below Charts on the left of the screen).
3. Go to Qlik Dashboard bundle
4. Go to Variable Input and drag it onto the screen
5. Under the variable tab on the right (when the Variable input object it selected), go to Variable and select vType under Name.
6. Under Show as, select Buttons.
7. Go to the Values tab and select Fixed.
8. Add an Alternative with Value 'EUR' and Label EUR.
9. 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

[Iras]

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 ? 

[Mauritz_SA · Accepted solution]

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

Just go the variable and update the description 👍.

[Iras]

Thanks alot..