Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Bar Chart with variable bar

Hi everyboy,

I need to create a bar chart with a variable bar depending on a setted value through an input box.

Example:

Each month of 2016 (green bar) should be the same value of 2015 plus 10%.

Is this possibe? Any suggestions?

Sem título.png

2 Replies
MVP
MVP

Re: Bar Chart with variable bar

Try a bar chart with dimension Month and 4 expressions ,like

=Sum({<Year = {2013}>} Sales)

=Sum({<Year = {2014}>} Sales)

=Sum({<Year = {2015}>} Sales)

=Sum({<Year = {2015}>} Sales) * (1+vPercentage)

vPercentage being your variable set in the input box

Highlighted
HirisH_V7
Honored Contributor

Re: Bar Chart with variable bar

Hi,

May be like this,

INPUTFIELD InputVar;

Data:

LOAD *,

0 as InputVar

INLINE [

    Customer , Sales

    1, 2200

    2, 1100

    3, 1200

    4, 1100

    5, 2100

    6, 12000

];

Front end :

Bar Chart with,

Dimension :

Customer

=ValueList('Sales')

Expressions:

=if(ValueList('Sales'),'Sales',Sum(Sales))

=if(ValueList('Sales'),'Sales',InputVar)

By Using Value list will call both of the expression into a bar like this,

Bar Chart with Input Variable-204505.PNG

Hope this Helps,

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”