This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
was wondering if anyone would be able to help me. I want to create a Dynamic Display of Y axis Data points in Qliview.
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...??
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
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.
Can you help me out..??
pls share sample app with data?
I cant Share the Data...!!
can you please write statement over here...
Thanks in advance.