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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Learnerr
Contributor III
Contributor III

If statament in Dimension

Hi all,

 

I have A sınıf,B sınıf and if nothing is A and B i would like to say C sınıf.

 

My if statement doesnt work:

=if(SATIS_SINIF= '001','A Sınıfı','002','B sınıfı','C Sınıfı')

What is wrong ,please?

 

Regards

1 Solution

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

Hi @Learnerr ,

You should use the expression below:

=if(SATIS_SINIF= '001', 'A Sınıfı',
if(SATIS_SINIF= '002', 'B Sınıfı'
, 'C Sınıfı' )

Best Regards

View solution in original post

2 Replies
agigliotti
Partner - Champion
Partner - Champion

Hi @Learnerr ,

You should use the expression below:

=if(SATIS_SINIF= '001', 'A Sınıfı',
if(SATIS_SINIF= '002', 'B Sınıfı'
, 'C Sınıfı' )

Best Regards

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

=if(SATIS_SINIF= '001',
  'A Sınıfı',
  If(SATIS_SINIF= '002',
    'B sınıfı',
    'C Sınıfı'
  )
)

or

=Pick(Match(SATIS_SINIF, '001', '002')+1, 'C Sınıfı', 'A Sınıfı', 'B sınıfı')
Help users find answers! Don't forget to mark a solution that worked for you!