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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register 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.