Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Calculated Column and Filter Issue

Hi!

I have a question about a issue in a calculated column and filter.

I've created a formula that return the values correctly.

When I put this same formula in a calculated column in the pivot, it returns the correct values.


But when I have a filter with this same calculation and then filter the data, the pivot returns me the wrong values.

Can you help, please?

Thanks.

The formula used for calculated column in pivot and filter is this one:

=if(not match([FIELD 1],'STRING 1','STRING 2') and [FIELD 2] = '*', 'RESULT 1',

if(WildMatch([FIELD 1],'STRING 1','STRING 2') and not match([FIELD 2],'STRING 4','STRING 3','STRING 5'),'RESULT 1',

if(WildMatch([FIELD 1],'STRING 1') and WildMatch([FIELD 2],'STRING 6'),'RESULT 2',

if(WildMatch([FIELD 1],'STRING 1') and WildMatch([FIELD 2],'STRING 5'),'RESULT 2',

if(WildMatch([FIELD 1],'STRING 2') and WildMatch([FIELD 2],'STRING 6'),'RESULT 2',

if(WildMatch([FIELD 1],'STRING 2') and WildMatch([FIELD 2],'STRING 5'),'RESULT 2',

if(IsNull([FIELD 2])=1,'RESULT 1',

if(len([FIELD 2])=0, 'RESULT 1',
if([FIELD 1]='*' and [FIELD 2] ='*', 'RESULT 1','RESULT 1')))))))))

Labels (3)
2 Replies
Highlighted
Partner
Partner

Re: Calculated Column and Filter Issue

i would suggest doing this calculation in the load script and create a column. Use that column in your table and filter
Highlighted
Partner
Partner

Re: Calculated Column and Filter Issue

Is not possible to do in that way because the columns are from different tables and isn't possible to join them on script.