Could variable solve this? and how?

n1ef5ng1 — Tue, 30 Jul 2013 06:10:02 GMT

Hi all,

I have this report format

Type	Revenue
Country_Departure	888
Country_Arrival	1199
Country	11111

I will need user to select the particular country and it will display the value. Say if the user choose France, it will show Country_Departure and arrival of France

However, the avaliable field I have is Country_Departure and Country_Arrival, I can't possibly ask the user to select both field france in order to show the result

In addtion, I have additional field call Group_Country where it will display out the countries in the world.

This is my Code for Country_Departure

(sum({$<Transit_Container_Class = {'F'},TXIT_Country.Departure= >} Transit_TEU) ))

I am thinking is it possible that if the user choose France, it will stored the value as an variable ,

and on the expression it will read the value of the variable and paste it on TXIT_Country.Departure.

If is possible how is it done, thank you

Re: Could variable solve this? and how?

n1ef5ng1 — Tue, 30 Jul 2013 06:19:22 GMT

Solved by

(

(sum({$<Transit_Container_Class = {'F'},TXIT_Group_Country.Discharge ={$(=(Group_Country))

topic Could variable solve this? and how? in QlikView

Could variable solve this? and how?

Re: Could variable solve this? and how?