Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

Variable Problem

Hi,

I have a table with sales by month. My Budget is in Dollar I need to convert in Pesos. So I have a variable that take the dollar. The problem is with my formula Divide by all months And produce a distorsion in the final information. For Example. Dollar in January is 772.000 If I do clic in January the information is fine because just take the avg of January. But if I selecte Jan and Feb. January takes another mount, This is because is divide for the avg January and February. I Would Like to see the same information in both cases. The field is called valor_dolar. The Variable (Is the first variable in the list)

Thanks!

1 Reply
pgalvezt
Specialist
Specialist
Author

Hi,

Any Help,

Thanks!