Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

6 Replies
Anil_Babu_Samineni

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
yoganantha321
Creator II
Creator II

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

MK_QSL
MVP
MVP

Check enclosed file..

Not applicable
Author

Hi Manish,

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

Regards,

Betty

MK_QSL
MVP
MVP

Can you elaborate please?

Not applicable
Author

I need single measure...

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