Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
reinholdgraf
Not applicable

show monthly figures, while a single month is selected

On main chart, I show figures according to the month, selected by the user.

On one extra chart, I want to show the total year, month by month (bar-chart). So here, the selected month shouldn't be considered.

I tried: sum({1} Sales)

It shows each month, but, if user selects other dimensions (e.g. Product, Sales Area, etc.), the bar-chart doesn't change; so other selections do not have influence on this chart.

Reinhold

Tags (1)
5 Replies
MK_QSL
Not applicable

Re: show monthly figures, while a single month is selected

Can you post sample application?

balrajahlawat
Not applicable

Re: show monthly figures, while a single month is selected

try this, bypass month field?

=sum({<Month=>} Sales)

reinholdgraf
Not applicable

Re: show monthly figures, while a single month is selected

Test-App attached.

Line-Chart should always keep displaying all months.

reddys310
Not applicable

Re: show monthly figures, while a single month is selected

Hi Reinhold,

If you want to ignore the filter try

sum({<Month=>}sales)

If you need the total then sum(Total Sales)

Thanks,

Sangram

reinholdgraf
Not applicable

Re: show monthly figures, while a single month is selected

This works, when using the date-field from the original source.

It doesn't work, when using the calendar-function.

Calendar:

Declare Field Definition Tagged '$date'

  Parameters

    first_month_of_year = 1

    Fields

    Year($1) As Jahr Tagged '$year',

        Month($1) As Monat Tagged '$month',

        Date($1) As Datum Tagged ('$date', '$day')

    Groups

    Jahr, Monat, Datum type collection as JahrMonatTag;

       

Derive Fields From Fields Date1 Using Calendar;