topic Re: Button Issue (QlikView 11) in QlikView

Button Issue (QlikView 11)

Anonymous — Tue, 12 Jun 2018 19:45:30 GMT

I am developing a dashboard in QlikView 11 installed on my laptop. And the data is loaded in from a xls file. I have numerous buttons that have the same code with exception for the string value, however, only some buttons work. Here is an example of the code and actions utilized:

Functional Button (This button works perfectly fine)
- Text: =Count(If(([Host Species]='Rat') and[Target Species]='Mouse'), [Target Species]))
- Actions:
  - Select in Field; Field = Host Species; Search String = Rat
  - Select in Field; Field = Target Species; Search String = Mouse
Dysfunctional Button (This button has the wrong count of 0 and does not make proper selections)
- Text: =Count(If(([Host Species]='Mouse’) and[Target Species]='Mouse'), [Target Species]))
- Actions:
  - Select in Field; Field = Host Species; Search String = Mouse
  - Select in Field; Field = Target Species; Search String = Mouse

Overall, the value ‘Mouse’ is just not working for me. I have reloaded the data several times and have tried to adjust the string, however, I have not been able to find a solution.

Re: Button Issue (QlikView 11)

isingh30 — Tue, 12 Jun 2018 19:46:48 GMT

Can you share your sample application?

Re: Button Issue (QlikView 11)

vishsaggi — Tue, 12 Jun 2018 20:31:59 GMT

Can you show Host Species and Target Species in your LIsbox and share some snapshots of the values they hold?

Re: Button Issue (QlikView 11)

Anonymous — Wed, 13 Jun 2018 13:35:20 GMT

Re: Button Issue (QlikView 11)

Anonymous — Wed, 13 Jun 2018 13:36:52 GMT

Unable to share the sample application unfortunately due to the sensitivity of the material.

Re: Button Issue (QlikView 11)

vishsaggi — Wed, 13 Jun 2018 14:07:48 GMT

It works for me. Are these two fields coming from different tables or from one table? Can you share your sample file here where you having this problem. If you use these expressions can you see 1 and 1 for both buttons in your dashboard.

Re: Button Issue (QlikView 11)

m_woolf — Wed, 13 Jun 2018 15:20:44 GMT

Try:

=Count(If([Host Species]='Mouse’ and[Target Species]='Mouse', [Target Species])