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

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
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
‎2017-04-03 06:27 AM

Adding Extra flag

HI All,

I am having Sales, taget in the Flag Columns.. Need to include one more flag with Naming 'Whole' in the Flag column for getting the sum of Sales + target  , How to acheive this...

Regards,

Betty

Sales.qvw
488 Views
0 Likes
6 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-04-03 06:33 AM

May be this?

If(Sales + target, 1, 0) as Whole

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
402 Views
0 Likes
yoganantha321
Creator II
Creator II
‎2017-04-03 06:35 AM

If you having Sales and Target in script while extracting, You can add Sales+target as whole in extracting script as another field

402 Views
0 Likes
MK_QSL
MVP
MVP
‎2017-04-03 06:39 AM

Check enclosed file..

Sales.qvw
402 Views
0 Likes
Not applicable
‎2017-04-03 08:11 AM
Author

In response to MK_QSL

Hi Manish,

But i need to see in single Measure only....

Regards,

Betty

402 Views
0 Likes
MK_QSL
MVP
MVP
‎2017-04-03 08:16 AM

In response to

Can you elaborate please?

402 Views
0 Likes
Not applicable
‎2017-04-03 04:17 PM
Author

In response to MK_QSL

I need single measure...

with various selections in Flag list box like Sales, Target, Whole

402 Views
0 Likes