Dynamic Displaying Y axis Data in Qlikview

[SK28]

Hi,

was wondering if anyone would be able to help me.  I want to create a Dynamic Display of Y axis Data points in Qliview.

Example.

TOTAL DATE RANGE - 201401  TO 201701(in YYYYMM Format)

COUNTRIES:  Date Range

USA                   201401 to 201701

INDIA                   201501 to 201701

AFRICA                 201508 to 201701

AUSTRALIA            201601 to 201701

so in Graph when I Select a Country, the Y- axis has to show based on the Selected Date range...?

in the above example

if I select USA  it has to Show the graphs between 201401 to 201701

for India - 201501 to 201701

Similarly for other Countries...??

Thanks,

Krishna

[buzzy996]

why it's dynamic y axis?

i think by writing simply if expression on expression tab u will get desire op.

and u can made ur selections,for exp if u select india u will only get the values corresponding to that date range only.

[SK28]

Can you help me out..??

[buzzy996]

pls share sample app with data?

[SK28]

I cant Share the Data...!!

can you please write statement over here...

Thanks in advance.

[buzzy996 · Accepted solution]

PFA, HTH.

Syntax: =Sum(If(country='AUSTRALIA' and [Invoice Date]>='01/01/2016',[Sales Amount],     If(country='USA' and [Invoice Date]>='01/01/2014',[Sales Amount],     If(country='AFRICA' and [Invoice Date]>='01/08/2015',[Sales Amount],     If(country='INDIA ' and [Invoice Date]>='01/01/2015',[Sales Amount],Null())))))

seems ur upper date limit is always current month last date ,so no need to include on syntax.