topic Re: Select same value throughout the document in QlikView

Select same value throughout the document

Thu, 10 Dec 2015 09:54:06 GMT

Hi all,

Although a selection in one sheet will reflect throughout the document, for some reason (i.e. include set identifier "1") this does not happen again in my document. I will like to reinforce this.

This is what i am after:

My document has two sheets: SheetA and SheetB.

Both Sheets have Date (list box).

If I select a date value in Date (list box) in SheetA and I open SheetB I want the same date selected.

Regards,

Re: Select same value throughout the document

Anonymous — Thu, 10 Dec 2015 09:59:17 GMT

then remove the inclusion of (i.e. include set identifier "1")

Re: Select same value throughout the document

karthikeyan1504 — Thu, 10 Dec 2015 10:00:58 GMT

By default qlikview will take the same date selection across the tab, if you have used the same field in all tabs...

Please check whether you have used the same date field in both the sheets..

if yes, please check whether you have any sheet level triggers in your qvw...

Re: Select same value throughout the document

Thu, 10 Dec 2015 10:03:33 GMT

Hi, the Set Identifier was include in SheetA for a purpose. What I want to do now is to work round it. That is if I select Date='Today' in SheetA and I open SheetB, I want to force SheetB to select Date='Today'

Re: Select same value throughout the document

Anonymous — Thu, 10 Dec 2015 10:05:12 GMT

can you post a sample/QVW?

Re: Select same value throughout the document

Thu, 10 Dec 2015 10:08:54 GMT

HI phresh ,

In qlikview you can select any value in one sheet it is applicable for all sheets,

you can to change that by using triggers or alternate state concepts

Re: Select same value throughout the document

buzzy996 — Thu, 10 Dec 2015 10:16:46 GMT

what ever u are asking in above is by default qlikview property.

and u are facing this issue because of ur set expression on ur sheetA.

so,u can try this ..create a macro and use that macro to trigger on each sheet.

Sub MacToday

ActiveDocument.Fields("UrdateField").Select Date(Now())

End sub

Re: Select same value throughout the document

buzzy996 — Thu, 10 Dec 2015 11:50:26 GMT

try tis,

Sub MacToday

ActiveDocument.Fields("UrdateField").Select Date(TODAY())

End sub

Re: Select same value throughout the document

Thu, 10 Dec 2015 11:56:52 GMT

Please is it possible to do this without a macro?

IF there is no is no selection in the document, Select Date (List box) = 'Today'

Re: Select same value throughout the document

Anonymous — Thu, 10 Dec 2015 12:00:44 GMT

Can you post a sample qvw?

Re: Select same value throughout the document

Thu, 10 Dec 2015 12:13:04 GMT

Sorry, I am not able to post the qvw at the moment.

Regards

Re: Select same value throughout the document

buzzy996 — Thu, 10 Dec 2015 12:42:56 GMT

try tis,