topic AW:Sheets in QlikView

Sheets

Fri, 18 Feb 2011 14:16:19 GMT

how can i make , not having connections between one sheet to another sheet. Here in two sheets i am using same objects and expressions. If i am changing any positions or values of particular object, it should not get effected with another sheet.

Can anyone reply me soon on this.

Thnks

AW:Sheets

Fri, 18 Feb 2011 14:18:11 GMT

Hi Venkat,

do you use linked objects? If so you simply remove the link between them...

cheers

Florian

AW:Sheets

Fri, 18 Feb 2011 14:24:14 GMT

HI Florian,

I didn't used any linked objects. But it is changing the data.

Thnks

AW:Sheets

Fri, 18 Feb 2011 14:29:53 GMT

Hi Florian,

I don't know what is linked objects, can you explain what it is and if it is present in my file how can i remove it. I am new QlikView technology. I think that i didn't done the part of the linked objects in my file.

Is there any other option to remove relation between the sheets

AW:Sheets

Miguel_Angel_Baeyens — Fri, 18 Feb 2011 14:42:57 GMT

Hello,

Since you load all records in the document, and because of the associative logic, all tables are usually associated between them, once you have selected a value in a record, it applies to all objects you have in your document, this is how QlikView works. However, depending on your data model and what you want to get, there are ways of making objects show the same information regardless the selections you are doing.

One simple way is right clicking on the object and selecting "Detach". This will keep the selections in the moment you click, but the graph won't change in spite of selections, until you attach it again.

You can get similar results using set modifiers and TOTAL keyword in your expressions

Sum({1} TOTAL Sales)

That will return the total aggregation of Sales.

Hope that helps.

AW:Sheets

Fri, 18 Feb 2011 15:08:50 GMT

hi Miguel,

Is there any other way otherthan detach.

Thnks

AW:Sheets

Miguel_Angel_Baeyens — Fri, 18 Feb 2011 15:17:44 GMT

Besides to what I mentioned above about {1} TOTAL, you can use set analysis to ignore selections in certain fields:

Sum({< CustomerID = >} Sales)

That will ignore any value selected in CustomerID.

And you always can create a model with different datamodels, not linked between them. Personally, I don't think it's a good idea, and I always prefer to create as many documents as necessary instead of a huge document that has all possible objects, and create complex expressions, conditionals... so the objects make sense.

But of course, it will depend on a lot of things.

Regards.

AW:Sheets

Fri, 18 Feb 2011 15:35:00 GMT

Hey Miguel,

But i need to ignore the sheet, when any selections occuring in current sheet the other sheet should be ignored or should not get any changes in fields, charts or any other objecs.

It is not only for few objects the entire sheet should not be changed. If i am moving to Second Sheet then here i done modifications it should not effect the first sheet.

In this process any sheet should not be hide or detached objects .

Thnks

AW:Sheets

Miguel_Angel_Baeyens — Fri, 18 Feb 2011 15:43:54 GMT

Then use bookmarks, kind of tricky but it should work. First, create one bookmark for each sheet in your document. Then, in each sheet create an action on leave (Sheet Properties, Triggers) "Bookmark", "Replace Bookmark". This way any selections done while in that sheet will be stored in its bookmark. Create a new action in Triggers for each sheet "On Activate", "Bookmarks", "Apply Bookmark", so the previously saved state of selections in that sheet will be applied each time the sheet is clicked.

Hope that helps.

AW:Sheets

Fri, 18 Feb 2011 16:06:39 GMT

Hey Miguel,

I tried what you said in the post on bookmarks, but it is also changing the values of other sheets. Ex: If i am saving the sheet1 as AddBookmark automatically in sheet2 also the bookmark is saving what i done in Sheet1.

Is there any other better choice in this query.

Thnks

AW:Sheets

Miguel_Angel_Baeyens — Fri, 18 Feb 2011 16:16:22 GMT

Well, yes, the order of actions On Activate should be first Clear All, then Apply Bookmark (Sheet1). Then any time you activate Sheet1 will have only selections kept in Bookmark for Sheet1, and so on with every sheet.

AW:Sheets

Fri, 18 Feb 2011 16:19:36 GMT

Hello Venkat,

On the other sheet where you dont want the objects to work on any selection, you need to right click on the object, Properties and then select DETATCH. This is an immediate and temporary solution though if thats of any use to you. Even my client had a similar requirement and as QV works on associative logic we can suggest them this.

AW:Sheets

Miguel_Angel_Baeyens — Fri, 18 Feb 2011 16:31:15 GMT

Hello,

Attached is a very simple example on how bookmarks will help you to keep selections for each sheet regardless what you have selected in the rest.

Hope that helps.

AW:Sheets

Fri, 18 Feb 2011 16:37:28 GMT

Hi Miguel,

I really thank to you giving immediate replies.

i tried it but now also same, it changing the selections in other sheets.

Is there any option by not using the Bookmarks.

Thnks

AW:Sheets

Miguel_Angel_Baeyens — Fri, 18 Feb 2011 16:44:43 GMT

I'm afraid I'm missing something, then.

When I go to Sheet1 and select Item A and Vendor A, then go to Sheet2, there are different selections done. Now in Sheet2 I select Item B and Vendor B, and go back to Sheet1, listboxes show Item A and Vendor A. Now go back to Sheet2 and you will see Item B and Vendor B. So, basically, selections are kept among sheets, and what you do in Sheet1 doesn' aply to Sheet2 and viceversa.

Are you experiencing something different?

AW:Sheets

Fri, 18 Feb 2011 17:03:47 GMT

No Miguel, i done what you said same but not getting it why so?

I will tell you clearly what i done upto now.

First i created Bookmark(it's id BM01) in sheet1 and then i selected sheet properties there i selected "Triggers". In Triggers i clicked on "On Activate" in this i add "ClearALL" from Selection and "ApplyBookmark" form Bookmarks and i given BookmarkId as BM01.

Second i created Bookmark(it's id BM02) in sheet2 and then i selected sheet properties there i selected "Triggers". In Triggers i clicked on "On Activate" in this i add "ClearALL" from Selection and "ApplyBookmark" form Bookmarks and i given BookmarkId as BM02.

That was what i done. Is there any mistake in this process?

Thnks

AW:Sheets

Miguel_Angel_Baeyens — Fri, 18 Feb 2011 17:48:43 GMT

Hi,

Yes, there are some differences to what I said. Have you checed the application I attached? Check there for bookmars, inline explanations and triggers in sheets.

Anyway, again, the order is

1.- Create as many bookmarks as sheets are the document has. Initially, these bookmarks will be empty.

2.- In every sheet, go to Sheet Properties and select Triggers tab, OnActivate, add the following actions:

a) Selections: Clear All

b) Bookmarks: Apply Bookmark (the ID of the bookmark created for this sheet, something like BM01)

3.- Go to OnLeaveSheet and add the following actions:

a) Bookmarks: Replace Bookmark (the same ID as in the previous point)

From now on, any actions you perform in one sheet will be kept for that sheet.

Check attached application for further reference.

Regards.

AW:Sheets

Sat, 19 Feb 2011 05:28:29 GMT

Hai Miguel,

I done same procedure what you given, but it happening like this: When i saving into bookmark in sheet1 the same action is also performing in Sheet2 bookmark. Now if i making changes the values in sheet2 then adding to bookmarks the same is reflecting into sheet1 and saving in bookmark.

If i am opening the bookmarks of saved list in both sheets it is displaying only the last added . The last added is either from Sheet1 or Sheet2 it is displaying on both same.

I am sending the Screenshots of my Sheet1 and Sheet2, please check this and reply to me.

SHEET1:

SHEET2:

Thnks

AW:Sheets

Mon, 21 Feb 2011 07:07:54 GMT

Hai Miguel,

In Sheet1, if i am adding bookmark to sheet1 the same added bookmark is also adding in the sheet2 bookmark.

I need to have the sheet1 should contain only its bookmark selected within it. And sheet2 should contain only its Sheet2 selected bookmarks.

This making the problem now.

Thnks

AW:Sheets

Miguel_Angel_Baeyens — Mon, 21 Feb 2011 09:26:56 GMT

Hello,

Go to the attached document, Bookmarks, and check that your settings are the same that in the document. (Checked "Document bookmark", "Include selections in bookmark", etc).

On the other hand, following the steps I described above, you first make the selections (for example, year 2010), then create the bookmark, which will store Year = 2010. Then Apply bookmark (nothing will happen now, since the selection saved in bookmark and in fields are exaclty the same). This will never affect to Bookmark 2.

Note that Bookmarks are selections saved, and you may have as many as you want, and they will not interfere between them (otherwise it wdill not make any sense).

Regards.