topic Re: Show data in Bar chart conditionally in QlikView

Show data in Bar chart conditionally

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

Hi All,

I want to show data in Bar chart conditionally for instance

1. take year in Listbox

2. take bar chart with x axis is year and y axis is sales.

I want to display Bar chart with current year data by default and rest of years based selections. (Current year is static and rest of years dynamic).

Thanks,

Nihhal.

Anil_Babu_Samineni — Mon, 03 Jul 2017 15:46:13 GMT

May be this?

If(GetFieldSelections(Year) = 0, Sum({<Year = {'$(=Max(Year))'}>} Sales), Sum(Sales))

nihhalmca — Tue, 04 Jul 2017 11:53:36 GMT

Hi Anil - Its not working.

ahaahaaha — Tue, 04 Jul 2017 12:05:30 GMT

Hi,

May be like this (look attached file)

Sum ({<Year=Year+{2017}>}Sale)

Regards,

Andrey