how to call a cell value from another sheet in qlikview

[#1]

Hi Friends ,

   how to call a cell value from another sheet in qlikview

[Miguel_Angel_Baeyens]

Hi,

You will need to specify the same expression for the same dimension. QlikView is not excel, and you cannot copy once cell value to another place. But say for example you have a table for months and Sum(Sales) as expressions, and you want to get only sales for February. You can use the following expression to get that value

Sum({< MonthNum = {2} >} Sales)

Where MonthNum is a field that already exists in your tables that stores the month number.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#3]

Hi Miguel Angel Baeyens

          Thanks For Your Valueable Reply .. Now I Post The Another Question with attachment .. please reply the solution as soon as possible