Conditional Show in Qlikview Reports

[Kiva]

I am a beginner to Qlikview. In the file I attached, I need to get the chart in the report only when the user selects age < 50 otherwise I should not get the bar chart.

How to give this condition in conditional show in reports Settings for Qlikview reports? examples are appreciated.

[sunny_talwar]

May be this

[Kiva]

Hi, 

Thanks for the reply. What does the Alt function do here and moreover given this When I select age greater than 50 ,I should not get the charts in reports. 

[avinashelite]

Alt function is just like case statement , it will check all the cases mentioned inside () with commas , which case is first encountered it will return that values else the last default value 

ALT(case1, case2,...., default)

[jonathandienst]

>>Alt function is just like case statement , it will check all the cases mentioned inside () with commas ,

Not exactly. The Alt will return the first valid numeric value from the list of parameters. Its more like a SQL COALESCE statement, except instead of returning the first non-null, ALT returns the first numeric value, or the last parameter if none of the preceding values are valid numerics.

In Sunny's example above, this means that conditional expression will return false() rather than an error is Age is undefined.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Condi...

[sunny_talwar]

Both the charts should not appear? Also, what happens when you have made no selection in Age field? You want to see those charts or hide them?

[Brett_Bleess]

Please be sure to return to the post and use the Accept as Solution button on any post(s) that helped you with your use case.  If you have further questions, be sure to leave an update post with what you still need.  If you ended up doing something different, consider posting what you did so other Community Members will know what worked for you in this use case, and once you post that, you can then use the Accept as Solution button on it to mark it.  

Below are a couple of specific Design Blog posts that may be helpful too:

https://community.qlik.com/t5/Qlik-Design-Blog/Enhancing-the-User-Experience-Using-Conditional-Expre...

https://community.qlik.com/t5/Qlik-Design-Blog/Enhancing-the-User-Experience-Using-Conditional-Expre...

Here is the base URL to the Design Blog area you can use to search there yourself, there are hundreds of mostly how-to items in this area written by our internal experts, so it should prove useful to you going forward.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett