Button Issue (QlikView 11)

[Anonymous]

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.

[isingh30]

Can you share your sample application?

[vishsaggi]

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

[Anonymous]

[Anonymous]

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

[vishsaggi]

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.

[m_woolf]

Try:

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