Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Select chart based on the user input text

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)

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi

Please

In Addons Uncheck Zero Values

if it is ticked it will give zero values

Thanks

 

View solution in original post

8 Replies
Highlighted
Partner
Partner

Hi

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 

Thanks

 

Highlighted
Contributor
Contributor

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.

NbI-clearance-in-dubai/ 

Highlighted
Contributor II
Contributor II

Dear Kashyap,

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 .

 

 

Highlighted
Partner
Partner

Hi

Sorry, I understood they are all different dimensions.

Try this in your dimension

if(ISnull(if(ServiceLine='$(Variable)',ServiceLine))=0,ServiceLine,'Total')

Hope this works for you

Thanks

Highlighted
Contributor II
Contributor II

Hi Kashyap,

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.

 
 
Highlighted
Partner
Partner

Hi 

Try this it is working but it is a little bit different

Dimension: ServiceLine

Measure: if(len(Variable)=0,Sum(Value),Sum({<ServiceLine={"$(Var)"}>}Value))

Note: 1) Make sure to uncheck null values in dimensions

             2) In Addons Uncheck Zero Values

 

Hope this helps 

Thanks

Highlighted
Contributor II
Contributor II

Hi Kashyap,

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 

 

 

Regards,

Pradeep K

 

 

Highlighted
Partner
Partner

Hi

Please

In Addons Uncheck Zero Values

if it is ticked it will give zero values

Thanks

 

View solution in original post