topic Re: Default tab value selection? in QlikView

Default tab value selection?

Wed, 20 Aug 2014 16:57:12 GMT

i created list box as led check box with 3 vaules

A , B ,C

and also i created 3 pivot tables related of A,B,C values

now if i click A , A pivot table displaying

if not seleted any value nothing will displayed

now i want display A value pivot table as default.

i used Getfiledselection function

Please help on that

Re: Default tab value selection?

Wed, 20 Aug 2014 17:00:09 GMT

Did you try Conditional Show in the Pivot Table in the Pivot Table.

Re: Default tab value selection?

Wed, 20 Aug 2014 17:02:55 GMT

yes i used

GetFieldSelections(ReportType.ReportName)='A'

The probleam is if i not seleted any thing nothing will displayed

if not seleted any thing i want to diaplay A pivot table as default

Re: Default tab value selection?

Wed, 20 Aug 2014 17:05:37 GMT

Can you post the file

Re: Default tab value selection?

Anonymous — Wed, 20 Aug 2014 17:14:20 GMT

you could try using a trigger:

go to settings > document properties > triggers > in "document event triggers", select OnOpen > click on add actions to the right > click Add in the Actions window > select Selection as Action Type and Action as Select in Field > click ok and in Actions window input fieldname that has the value A and in search string input 'A'.

this way value A will be selected by default whenever the document is opened.

Re: Default tab value selection?

Wed, 20 Aug 2014 18:07:38 GMT

In the A chart, you can add the following expression in the Show field:

GetFieldSelections(Value) = 'A' or GetSelectedCount(Value) = 0

I have attached s sample, let me know if this helps out.

Re: Default tab value selection?

Anonymous — Thu, 21 Aug 2014 07:41:28 GMT

hi,

Please use,

Settings --> Document Properties -->Triggers -->Document Event Triggers -->select On Open<Has Action(s)> OR OnPostReload<Has Action(s)> --> Click Add Action(s)... --> Add -->Select Action Type (Selection)

& Action (Select in Field) --> click Ok.-->Enter field & Search string.

After that Reload OR Open your QVW file. Default Value will selected in your file.