Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-12-07 08:14 AM

how to create a list box with two values by writting an expression instead of taking system fields?

how to create a list box with two values by writting an expression instead of taking system fields?

250 Views
0 Likes
2 Replies
Not applicable
‎2010-12-07 09:00 AM
Author

Hi 3,

Find the attacment.Let me know if you have any issue

Thanks & Regards

Jai

year_comp.qvw
165 Views
0 Likes
Not applicable
‎2010-12-08 01:05 AM
Author

In response to

heiio jai,

actually we have to create a calculated dimension in that list box.in our database there are 2 diff. fields namely "Invoice Quantity" and "Contract Quantity" in two diff. tables.we want to show the calculated dimension (Contract Quantity - sum(Invoice Quantity) ) as "Contract Status" so that it can work on individual item seperately.and we also want to asign two values in the list box "Contract Status" namely "PENDING"(if "Contract Status">0) else "COMPLETED".

165 Views
0 Likes