topic Re: Dynamic Displaying Y axis Data in Qlikview in QlikView

Dynamic Displaying Y axis Data in Qlikview

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

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

Re: Dynamic Displaying Y axis Data in Qlikview

buzzy996 — Tue, 31 Jan 2017 14:51:37 GMT

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.

Re: Dynamic Displaying Y axis Data in Qlikview

SK28 — Tue, 31 Jan 2017 15:08:46 GMT

Can you help me out..??

Re: Dynamic Displaying Y axis Data in Qlikview

buzzy996 — Tue, 31 Jan 2017 15:14:14 GMT

pls share sample app with data?

Re: Dynamic Displaying Y axis Data in Qlikview

SK28 — Wed, 01 Feb 2017 10:29:21 GMT

I cant Share the Data...!!

can you please write statement over here...

Thanks in advance.

Re: Dynamic Displaying Y axis Data in Qlikview

buzzy996 — Thu, 02 Feb 2017 13:45:36 GMT

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.