Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
skkrishna
Contributor III
Contributor III

Dynamic Displaying Y axis Data in Qlikview

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

1 Solution

Accepted Solutions
buzzy996
Master II
Master II

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.

View solution in original post

5 Replies
buzzy996
Master II
Master II

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.

skkrishna
Contributor III
Contributor III
Author

Can you help me out..??

buzzy996
Master II
Master II

pls share sample app with data?

skkrishna
Contributor III
Contributor III
Author

I cant Share the Data...!!

can you please write statement over here...

Thanks in advance.

buzzy996
Master II
Master II

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.