Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
hs219
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
dilipranjith
Partner
Partner

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

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