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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

exclude

I want to exclude an  invoice number from the list box as default. but would like to use it when required .. is there a good way?

Labels (1)
26 Replies
Jason_Michaelides
Partner - Master II
Partner - Master II

What do you mean?

Jason Michaelides

Mobile: +44 7866 428 555

Email: jmichaelides@calibrateconsulting.com

raadwiptec
Creator II
Creator II
Author

similiar to list box .. keep one value selected?

Anil_Babu_Samineni

Have you checked Properties of Always Select one Value.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable

In case of Text Box, you can't. But you can fix the value by passing the dims in expression like this?

=Sum({<Year, Month, Day>} Sales)

Now, in above expression if you select any value of Year,Month, Day then your text box expression value will not change!

Hope this will help !!

Jason_Michaelides
Partner - Master II
Partner - Master II

What do you want to lock? Please specify what you want to do and what the result(s) should be.

raadwiptec
Creator II
Creator II
Author

hi jose

this looks good..but how do bring back the excluded if required

jmvilaplanap
Specialist
Specialist

Using the field "Exclude" as a filter, in a listbox.

If is not selected, you can see all the invoices, if the value "1" is selected then you will see the excluded invoices, and with "0" the not excluded invoices.