topic Re: Sheet Navigation with Specific Chart (Auto Hide and Show) in Visualization and Usability

Sheet Navigation with Specific Chart (Auto Hide and Show)

Anil_Babu_Samineni — Sat, 10 Feb 2018 14:28:32 GMT

Hello World,

FYI I've attached sample application to test.

If you notice 2 sheets, there is one called Dashboard one more for Admin Page which should filter from there

So, If From Admin sheet once we hit Country (Either 1/2/3/4) which should navigate to First sheet and it will get suitable needed.

Use case - If Country1 select from Country Filter The dashboard should visible only Country1 Which means Remain all should be hide. Till here we are in good. The big challenge here is if we select Country3 from Admin page it should place in Country1 that means (Auto Place order in first place). So, that it should navigate to each like versa.

Note - There is Submit and Clear button in Admin sheet. This all effects only works when Button Clicked (that means dynamic)

Free to ask in case, Anything needed from my end. So, far My company Certify these extensions.

1) Sheet Navigation - Qlik Branch

2) Show Hide Container - Qlik Branch

Best,

Anil

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anonymous — Sat, 10 Feb 2018 15:20:55 GMT

Have you attached the correct qvf ?

Neither of the 2 extensions you mention appear to be used, nor is there the Submit and Clear button in Admin sheet you mention. I am confused.

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anil_Babu_Samineni — Sat, 10 Feb 2018 15:30:07 GMT

You are not seeing this?

Anyway, May be you need to Download those extension to look the preview of my file. Update File (PFA)

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anonymous — Sat, 10 Feb 2018 15:53:31 GMT

I see this in edit mode, as in only 2 object viz's

I have the 2 extensions installed and am using QlikSense Desktop September 2017, 11.14.3

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anil_Babu_Samineni — Sat, 10 Feb 2018 17:08:35 GMT

Did you place new file to exist one? Please download latest one and check? Mine is QS Nov 11.24.1 (Won't help the version as support from QS 3.2 with those extensions )

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anonymous — Sat, 10 Feb 2018 17:27:10 GMT

Ain't got a clue what's up,

I have deleted everything, cleared my caches, re-downloaded, re-installed and still the same.

Hopefully somebody else will pick up this thread and we'll see what happens to them.

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anil_Babu_Samineni — Sat, 10 Feb 2018 17:59:47 GMT

That is make sense, Have you opened from Desktop / Hub? If it is desktop, Not sure what is the problem. If it is Hub try to open same In Chrome ??

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anonymous — Sat, 10 Feb 2018 18:09:08 GMT

Desktop on my private PC. Both native desktop and via Chrome.

Have upgraded to Qlik Sense Desktop November 2017 Patch 1 and still the same.

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anil_Babu_Samineni — Sat, 10 Feb 2018 18:12:28 GMT

UN-Expected outcome from you? Not even sure, What was the issue. Anyway, One last question do you have latest file which upload by "Feb 10, 2018 10:30 AM". If so, Could be something weird happened. Need to troubleshoot that.

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anonymous — Sat, 10 Feb 2018 18:20:48 GMT

The file is dated Feb 10, 17:18. Which is when I downloaded it UK time.

I can happily put new viz's on with the 2 extensions you mentioned, there is just no sign of the bottom 2 viz's on your screen shot.

If you have time and want to make sure then maybe create a version called say Sample2 and put a text box saying Sample 2.

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anil_Babu_Samineni — Sat, 10 Feb 2018 18:29:40 GMT

Done as request. There is file name called Sample_v2 May be download that which i can see the same visualization (2 viz's). Still same issue?

Finally, I am happy to take if you can drag based on that (Spare time)

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anonymous — Sat, 10 Feb 2018 18:47:55 GMT

Wow !! On Sample_v2 I can now see the two viz's calling swr-sense-navigation.js

I can't see FEI-ShowHide.js being called anywhere, is that what you would expect ?

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anil_Babu_Samineni — Sat, 10 Feb 2018 18:54:10 GMT

Great, Somewhat you Visible those.

Did you got my Question? Or you want to refrain the same in detail?

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anonymous — Sat, 10 Feb 2018 19:38:07 GMT

Do you mean :

Have just one ShowHide Container viz and on :

Select Country1 Show only Country1 viz
Select Country2 Show only Country2 viz
Select Country3 Show only Country3 viz
Select Country4 Show only Country4 viz

Or do you mean have 4 ShowHide Container viz's and always put the selected country in the left hand viz and the other 3 Countries in the other 3 viz's

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anil_Babu_Samineni — Sat, 10 Feb 2018 19:43:32 GMT

First Approach is what i am thinking now. But, If you select Country3 from selection it should show only Country3 and remain should be hide because we select Country3. And, It should place in first diagram (Auto - Resize where Sense don't have future). Even, that is fine as we don't have that future.

I am going to sleep now, Will catch you next login. May be ask still need any information now. I may wait next 15 minutes for you to solve the thread ..

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anonymous — Sat, 10 Feb 2018 20:18:48 GMT

See attached qvf.

First option is the single viz bottom right

Second option is the 4 viz's along the top.

Bottom left I have put a List Box and a Text Box of only(Country) that I used for testing.

Note: If you select no countries or more than 1 country it will display Bill Default in all 5 viz's

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anil_Babu_Samineni — Sun, 11 Feb 2018 02:20:50 GMT

As i stated initial, Till here i am in good stage. The red part is what i am trying? Can we place same Country3 over Country1 like Qlikview?

Use case - If Country1 select from Country Filter The dashboard should visible only Country1 Which means Remain all should be hide. Till here we are in good. The big challenge here is if we select Country3 from Admin page it should place in Country1 that means (Auto Place order in first place). So, that it should navigate to each like versa.

Update:

One more Drawback, I noticed here is If i select 2 Countries at a time it should show 2 countries Viz's (Make sense?)

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anonymous — Sun, 11 Feb 2018 07:49:58 GMT

I am confused as to what is meant by the red text. Could you clarify.

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anil_Babu_Samineni — Sun, 11 Feb 2018 07:54:17 GMT

Sure, IF you look my reports there is 4 viz's which should auto place.

Use case - If Country1 select then Country1 viz will effect for sure, But in sense, If we select Country3 then 1,2 and 4 should be hidden and the place where Country1 should replace to Country3. In Qlikview we have overlap future and does not handy with sense. I thought to check before commit to Users for the same

One more Drawback, I noticed here is If i select 2 Countries at a time it should show 2 countries Viz's. But, This is showing only one Viz only (Make sense?) - More insight could be Adhoc Reports where i am thinking after your words.

Re: Sheet Navigation with Specific Chart (Auto Hide and Show)

Anonymous — Sun, 11 Feb 2018 15:07:17 GMT

If I am understanding you correctly then maybe something like the attached qvf.