Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Default tab value selection?

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

6 Replies
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

Can you post the file

Anonymous
Not applicable
Author

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.

Not applicable
Author

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.

Anonymous
Not applicable
Author

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.