Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
stonecold111
Creator III
Creator III

if condition to set analysis

Hi qlikss

If(field1='abc' and field2='def','abc',field2)

can i write this in set analysis

4 Replies
sunny_talwar

AFAIK, this cannot be converted into set analysis

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

What exactly you want to achieve. Do you want to use this expression in any aggregation function, because set analysis will be used only in aggregation functions.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
trdandamudi
Master II
Master II

Can you give us more details... Where are you using this If statement in the script or front end. You need a aggregation function like Sum, Count etc.. to use set analysis.

stonecold111
Creator III
Creator III
Author

leave it.. just i want to know.. thanks