Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

Show data in Bar chart conditionally

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.

1 Solution

Accepted Solutions
Highlighted
Master
Master

Re: Show data in Bar chart conditionally

Hi,

May be like this (look attached file)

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


Regards,

Andrey

View solution in original post

3 Replies
Highlighted

Re: Show data in Bar chart conditionally

May be this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Specialist II
Specialist II

Re: Show data in Bar chart conditionally

Hi Anil - Its not working.

Highlighted
Master
Master

Re: Show data in Bar chart conditionally

Hi,

May be like this (look attached file)

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


Regards,

Andrey

View solution in original post