Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
leale1997
Contributor III
Contributor III

Can I use more than one Alternate State on a Chart?

I have a Chart that I have turned into a drop down list. 

There is a selection box that allows for me to set the Chart to one "Alternate State".

I would like the Chart to respond to more than one 'Alternate State'

12 Replies
leale1997
Contributor III
Contributor III
Author

=num(count({<legproject=$::LegProject,LegSourceType=$::LegSourceType,LegProject='CAPA','Product Complaint','Evaluation','Data Source','Deviation','OOS','EMIR','VSCR','UIR','Assessment','Change Source'}>

+<LegProject=$::LegProject,LegSourceType=$::LegSourceType,LegProject={'Observation'}, LegSourceType={'GMP Quality Compliance','Regulatory Agency'}>} DISTINCT LegRecordID), '#,##0', '.' , ',' )

I am getting an "error in set modifier expression"

Should I use 'or' instead of ','?

Gysbert_Wassenaar

My mistake, a typo. There should be an opening curly bracket in LegProject='CAPA' between the = and 'CAPA'.

=num(

    count({<

            ProjectType=$::ProjectType,

            SourceType=$::SourceType,

            LegProject={'CAPA', 'Product Complaint', 'Evaluation', 'Data Source', 'Deviation', 'OOS', 'EMIR', 'VSCR','UIR', 'Assessment', 'Change Source'}

           >

           +

           <

            ProjectType=$::ProjectType,

            SourceType=$::SourceType,

            LegProject={'Observation'},

            LegSourceType={'GMP Quality Compliance', 'Regulatory Agency'}

           >}

           DISTINCT LegRecordID

         ),

    '#,##0',

    '.',

    ','

    )


talk is cheap, supply exceeds demand
oknotsen
Master III
Master III

If your question is now answered, please flag the Correct Answer and Helpful Answers to close the topic.

If not, please let us know what part of this topic still needs answering .

May you live in interesting times!