Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
Did you try Conditional Show in the Pivot Table in the Pivot Table.
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
Can you post the file
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.
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.
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.