Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
venkat1
Creator II
Creator II

How to write expression with if else condition

Hi all 

I need to show the sales and purchase data for  today sales if the year and month slections are not selected,if I select year or month then sales and purchases data should come with relevant field sletion.

Please help me out of this 

thank you 

1 Reply
gf
Creator III
Creator III

Try it like this:

=if(GetSelectedCount(JAHR) <> 0 AND GetSelectedCount(FCO) <> 0,SUM( {$<JAHR={'vYearToday'}, MONTH={'vMonthToday'}>} SALDO),SUM( {$<YEAR = {'vSelectedYear' }, MONTH={'vSelectedMonth'}>} SALDO))