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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
loulacoetzee
Contributor
Contributor

Use Object Id for show condition

Is it possible to use a Object Id no in a show condition in a straight table instead of a fieldname?

e.g.

//GetSelectedCount([FinYearPsemas]) = 1

GetSelectedCount(ObjectId = "LB63") = 1

I get errors in my expression.

Thanks

7 Replies
Anonymous
Not applicable

sunny_talwar

When you make selection in your straight table, wouldn't it automatically select some fields? Why not use one of those fields? The reason I say that is because, I don't think QlikView directly allows for what you are trying to do here.

Colin-Albert
Partner - Champion
Partner - Champion

Have a look at the help. GetSelectedCount requires a fieldname as a parameter not an ObjectID

getselectedcount (FieldName [, IncludeExcluded [, State]])

Returns the current number of selected values in a field

Not applicable

I don't think it is possible, as my understanding is, the whole background data model is based on Field names, rather than the objects they  are into. Thanks!

loulacoetzee
Contributor
Contributor
Author

Thank you!

ramasaisaksoft

Hi Loula,

if possible create a Inline script after you developed the entire UI

fields like may be

Load * Inline [

ObiID,ObjName

1,tb1

2,mu1,

.....

];

then create a list box on these list(ObiID)

call this field in Straight table.

each chart need to hide/show depends on your objid.