Thanks for the PowerPoint presentation 👍 It is very helpful
You created two vSheetNo while you only need one, as this variable contains 1 when you want to show the World tab or 2 when you want to show the State's. You should delete the one with the dot at the end, like vSheetNo. (stay away from special characters like dots, commas or semicolons when assigning names to variables, even though you can use them, they could bite you back later in the logic.
Your assignments to the vSheetNo on the Sheet1's action, and its Button are perfect! 👍
Your assignments to the vSheetNo. on the Sheet2's action and its Button are not correct, you should be using vSheetNo instead (without the ending dot)
Your assignments to the Container's tabs' Show Conditions does not looks good, both of them should use vSheetNo (so forget about vSheetNo. -the one ending with a dot); I can't see the conditions clearly, anyhow I am typing them below; there is a comma, I think you used a dot instead (but I could be wrong, as dots and commas are hard to tell apart -another reason to avoid them when naming variables)
=If(vSheetNo = 1 , 1)
and
=If(vSheetNo = 2 , 1)
The way to read the condition is, when vSheetNo is equal to 1, the first condition returns 1 (true) while the second condition returns null (false), so the World wise details' tab is shown, while the State wise details remain hidden.
When the vSheetNo is equal to 2, it reverses the value returned by the conditions swapping the tab shown.
BTW, beautiful dashboard, I understand you are learning Qlik and started this project 5-7 days ago, very impressive!!
Hope this helps,
Arnaldo Sandoval A journey of a thousand miles begins with a single step.
Now its working perfectly thanks a lot🙏 from my heart.
Yes I have start working on Qlik sense 5-6 days ago earlier that I was working on PowerBI. but I noticed in Qlik sense things are not easy as other BI tools like PBI, Tableau. For Qlik sense I have search many videos and tutorials but I didn't found any relevant stuff for beginners specially where I can learned show/hide technique, Bookmarks, color expression✍️, drilldown etc.....if you have any site and know the relevant link can help for me please let me know
And Thanks for liking my dashboard and ppt presentation.
and Thanks for giving your valuable time for beginners yours time can make us expert!😊
My exposure to other BI tools is very limited, I invested my time mastering Qlik, I am watching a tutorial video on Tableau while trying to identify strengths and weaknesses between both products, so far I still find Qlik a very powerful tool, and I agree there are not many Qlik Tutorials around, perhaps because mastering Qlik Knowledge split between different areas, User Interface, Scripting, QMC -Qlik Management Console- Security Rules, etc; and two types of users, those with programming background and those without it, so any comprehensive training video is hard to get by, actually AnswerSharks produced several videos a long time ago, for QlikView, their videos are still relevant for scripting. I could end writing some tips and tricks documents one for Scripting, another for User Interface, perhaps I could try producing videos, I do not know yet, just thinking about it.
I found your professional background, very impressive, it is a pleasure chatting with you!!!
Arnaldo Sandoval A journey of a thousand miles begins with a single step.
Thanks for your thought and it would be great if you create your own videos or You tube channel for beginners from basic to advanced. andsurely I will watch AnswerSharks .
