Discussion board where members can get started with Qlik Sense.
Hi Experts ,
I have a scenario.
for example , i have the bar chart dimension is service line(Values like: ERS,CCI,DPO ), expre is count (emp), and i have the input box , in that input box i have given the input like ERS, based upon input chart will be display. (in Qlik Sense)
Try creating a variable with the input box
Give this expression in dimension
If(VariableName= 'ERS', ERS , If( VariableName= 'CCI' , CCI, If( VariableName= 'DPO ' , DPO , ERS)))
Hope this helps
NBI Clearance as it states that they have good character and are not a criminal. But, while working in Dubai, it doesn’t seem necessary, as can be used for immigration and other purposes.
Thanks for reply,
but if I have 100 records in a [service line] field , that time shall I write 100 if conditions for all ? .
But Based on the input text [service line] field value will be displayed in a chart, this is i'm expecting .
Sorry, I understood they are all different dimensions.
Try this in your dimension
Hope this works for you
Thank you so much for your reply
what you are given the logic is working fine, but one small modification is required in that . if I am not enter any value of the [service line] field it will shows the TOTAL value in one Bar, but instead of Total I would like to display the entire [service line] values in the bar chart.
Try this it is working but it is a little bit different
Note: 1) Make sure to uncheck null values in dimensions
2) In Addons Uncheck Zero Values
Hope this helps
Thanks for your reply,
what you are providing the expression is working fine but one thing is Chart is display the input value and along with remaining values. But I want to display the only input value on the chart not remaining.
for reference please check below image