topic Re: Objects layout in QlikView

Objects layout

Fri, 17 Jul 2015 08:20:46 GMT

Hi everyone!

I have a question concerning objects layout. Is it possible to script it?

Briefly my problem is the following. There are few obgects (for example, 6 diagrammes) in my QV document. For each one there is a button function of which is showing these objects. To make diagramme visible you need to click on an appropriate button. And I want these objects to be sorted depending on chosen buttons.

I really hope that my problem is more or less clear.

Many thanks in advance!

Marina

Re: Objects layout

MK_QSL — Fri, 17 Jul 2015 08:22:02 GMT

What type of sorting you want to do? Can you clarify with a sample app as an example?

Re: Objects layout

awhitfield — Fri, 17 Jul 2015 13:54:07 GMT

Hi Marina,

please clarify exactly mean by sorting in this instance.

Andy.

Re: Objects layout

Tue, 21 Jul 2015 10:30:13 GMT

Hi, Manish and Andrew!

That is not exactly sorting. I've made an example. In this document every button relates to a certain graph. I need the following

On the first sheet you can choose (click on) as much objects (buttons) as you want. Then you click on 'Show' and go to the next sheet where these objects are represented. But, viewer can click on, for example, Q3 and Q4 (ignoring Q1 and Q2). In this case respective graphs will be located lower than I need. But they should replace Q1 and Q2 if latest weren't chosen.

That is only example. By sorting I meant arranging of only chosen objects from the top of the page.

Many thanks in advance!

Marina

Re: Objects layout

alex_millan — Tue, 21 Jul 2015 11:06:16 GMT

Hi Marina,

taking into account that all objects share the same expression (only that every one refers to a different quarter), you can condition your expression to fit your requirement.

Now the buttons for the quarter toggle to set the variable to show/unshow its respective chart on the "Questions" sheet.

See the attached example.

HTH

Regards

Re: Objects layout

awhitfield — Tue, 21 Jul 2015 11:20:53 GMT

Ni Marina,

a neat solution would be to place the resultant charts in a container object

HTH Andy

Re: Objects layout

Tue, 21 Jul 2015 11:46:30 GMT

Hi Alex!

Many thanks for your way of solution!

Q1-Q4 are not quarters, these are indicators which do not share the same expression. In attached doc there is dummy data used just for visualization my problem. In a project there are much more indicators and expressions are more complicated.

Anyway, this nested IF-expression isn't working properly: when you choose, Q2 and Q3, for example, in result avg(Q2) is shown in both charts. How could it be improved?

Thank you for your help!

Marina

Re: Objects layout

alex_millan — Tue, 21 Jul 2015 11:48:56 GMT

Hi Marina, in relation to the bug when selecting Q2 and Q3 has been fixed on my last edition to the message

Re: Objects layout

Tue, 21 Jul 2015 11:55:38 GMT

Alex, so sorry!

I started working in document and didn't noticed how damaged it

Re: Objects layout

alex_millan — Tue, 21 Jul 2015 12:01:54 GMT

No problem! Let me know if you need further help.

Best regards

Re: Objects layout

Tue, 21 Jul 2015 13:15:30 GMT

Alex,

could you, please, specify is there any restriction on the number of IF in the nested IF-expression (as it is in MS Excel)?

Marina

Re: Objects layout

alex_millan — Tue, 21 Jul 2015 13:21:11 GMT

By now, I've never came accross any limitation, I can't assure you but nested a couple of times approx 20 conditions and worked. But notice that nested conditionals implies worse performance.

How many conditions are you planning to nest? Depending on this number, you may better go for another solution.

Re: Objects layout

Tue, 21 Jul 2015 13:26:59 GMT

Alex,

approximately 16 - as much as indicators I have. What do you mean by worse performance? Slow updating?

Re: Objects layout

alex_millan — Tue, 21 Jul 2015 13:35:03 GMT

Yes, I mean slow object refreshing and calculation.

But before worrying too much, try this solution and see how it works: if you experience a slowdown, go for another approach, but it can work perfectly well. I'd give it a chance for these conditions only applies to variable's values, not on difficult calculations, so I would bet it can work well.

Hope that helps and remember to close the thread when you consider you solved your doubt.

Cheers!

Re: Objects layout

Tue, 21 Jul 2015 13:43:48 GMT

Alex, thank you so much!

Re: Objects layout

alex_millan — Tue, 21 Jul 2015 13:50:31 GMT

You're welcome Marina!

You can mark the answers as 'useful' or 'correct'. By selecting one answer as correct you're able to close the thread.

Don't forget to do it: that may help others with the same issue as you to find a proper solution.

And do not hesitate to share any doubt that may show up

Re: Objects layout

Tue, 28 Jul 2015 14:42:50 GMT

Hi Alex!

I have the same problem as some time ago. You helped me to solve it (your decision attached). But as far as I have 15 objects instead of 4 this decision doesn't seem an appropriate one.

Could you, please, help me?

Many thanks in advence

Marina

Re: Objects layout

Tue, 28 Jul 2015 15:42:11 GMT

Hi Andrew!

Could you, please, clarify, is it possible to apply sorting in a container object and represent only part of objects depending on buttons that are clicked on?