Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Converting If Condition To Set Analysis

Hi,

I am trying to compare two fields in Qlikview with Set Analysis. Logic is working with if condition but lot of fields needs to be applied so I am trying to avoid if condition and want to have set analysis(Need to apply more 6 fields) !.

Attached is the Qlikview Application with Straight table that has an expression of if and needs to be converted in the set analysis.

Thanks,

Piyush

3 Replies
Highlighted

I don't think this can be converted to set analysis with the way the data is structured right now.

Highlighted
Partner
Partner

U can't compare in in set analysis ,

Try to create flags in back end adn filter it out in front end.

In expression if don't want to use if condition in set analysis , then create one calution dimention an apply supress null value.

-Nagarjun

Highlighted
Not applicable

Thanks for the reply.

As there are lot more fields going to come and Its many to many relationship with the data and dimension.If I tried to do it in the backend it might increase the fact. So its very difficult to do it in backend.

Thanks,

Piyush