Pivot table with selecting month

[Anahita]

Hi,

l’m new in Qlik Sense, I want to show sum(Revenue) by branch, name and month in a pivot table. Month is chosen by user. I don’t know how to connect date to pivot table

column:

name

row:

branch

measure:

sum(revenue)

[rubenmarin1]

Hi, this should be done on data model, when loading the data. Month or date should be related to the revenue, so when the user selcts one value on month or date it filters the revenues values on that month or date.

[Vegar]

If you have a date field (assuming it's named [Date]), them you can get month by adding a dimension defined as "=monthname([Date])" or "=month([Date])"

Or even better...

You create a [Month] dimension in the script.

Load ...

Monthname ([Date]) as year_month,

Month ([Date]) as month,

...

From Source