How to switch between months with the values only changing

[JoeyPob1214]

Hi everyone!

I'm new in using qlikview, I was wondering how can I create for example when I clicked a month, let say January it will show specific values for the month of January then when I clicked February it will show the same table but the values for February. In my example the values of Sales will the only one will change.

For Example:

January

Employee             Sales

Employee A          100

Employee B          200

Employee C          120

Employee D          400

____________________

February

Employee             Sales

Employee A          120

Employee B          220

Employee C          140

Employee D          120

[Somasundaram]

Hi,

Load 

Tablename() as Month,

Employee,

Sales

from data source;

Try to load like above script.

[JoeyPob1214]

after what should I do?

[Somasundaram · Accepted solution]

hi,

Create a straight/ Pivot table  with Employee as dimension and measure as a sales.

Create a list box with month.

Select the month based on the month table will show the values.