Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
In an expression, you can now write something like IF($(vType)='HR',Sum(Sales),Ave(Sales))
Hope this helps.
Regards,
Mauritz
Assign a value to the variable description like 'EUR' in step 1.
Just go the variable and update the description 👍.
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?
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 ?
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
Agree with @Mauritz_SA
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 ?
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:
In an expression, you can now write something like IF($(vType)='HR',Sum(Sales),Ave(Sales))
Hope this helps.
Regards,
Mauritz
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 ?
Assign a value to the variable description like 'EUR' in step 1.
Just go the variable and update the description 👍.
Thanks alot..