Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Different field names with same value

Hi,

I have an excel table for Target and it contains only month like Jan,Feb.This field is MONTH.

Achievement % is from other qvds and the calculation is done in set analysis . all other qvds are linked to calendar which has field Month.

for showing target and achievement in pivot table if I add MONTH to column target will show the value because for achievement it is Month. 

How to solve this. 

1 Reply
Highlighted
Creator III
Creator III

I'm not sure what you mean. Do you want to join MONTH to Month? During load, rename Month to MONTH (or MONTH to Month). 

If you don't want to join the two fields during load, you can use the P() function in set analysis, like {<Month=P(MONTH)>}