topic Re: How to switch between months with the values only changing in QlikView

How to switch between months with the values only changing

JoeyPob1214 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to switch between months with the values only changing

Somasundaram — Tue, 26 Mar 2019 07:33:39 GMT

Hi,

Load

Tablename() as Month,

Employee,

Sales

from data source;

Try to load like above script.

Re: How to switch between months with the values only changing

JoeyPob1214 — Tue, 26 Mar 2019 08:02:31 GMT

after what should I do?

Re: How to switch between months with the values only changing

Somasundaram — Tue, 26 Mar 2019 08:07:39 GMT

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.