Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Thanks for the helpful answers.
Instead of concatenating the attr values, we want to display the attr value of the maximum date..
in the given example,
Input
ID, attr, Date , value
1, a , 03/03/2014, 10
1, b, , 04/03/2014, 20
Output
ID, attr, Date1, Date2, Variance
1, b, 10 ,20 , 10
can someone please provide me the expression to do so?
Thanks
Can you share some more data?
Hi
You want to do this at script level or Front end chart Exp?
@@@
Hi Manish,
Thanks for the quick response.
The deatils are on the following thread
http://community.qlik.com/thread/109427
and I want to do this at the chart level..
In the attatched Report, for ID 1, as the attr value is different from Date1 to Date2, it displays them as 2 rows.
but, I want to display just one value which is maximum(Choosen dates)'s Value.
Thank You
Like this?
No,...I have date displayed in 2 filters as showed in the attached qvw.
I want the expression something similar to the following..
If( Date1>Date2, maxstring('$<Date = {'$(=GetFieldselections(Date1))'}>}Attr), MaxString({$<Date = {'$(=GetDFieldSelections(Date2))'}>}Attr))
Thanks
Try this:
For a calculated dimension:
=aggr(If( GetFieldselections(Date1)>GetFieldSelections(Date2), maxstring({$<Date = {'$(=GetFieldselections(Date1))'}>}Attr), MaxString({$<Date = {'$(=GetFieldSelections(Date2))'}>}Attr)), ID)
For an expression:
=if( GetFieldselections(Date1)>GetFieldSelections(Date2), maxstring({$<Date = {'$(=GetFieldselections(Date1))'}>}Attr), MaxString({$<Date = {'$(=GetFieldSelections(Date2))'}>}Attr))
If you don't plan on having the person select more than one Date2 or more than one Date1, this will do it. You were close, just had to make some adjustments. See attached.
Hope this helps!
Awesome!.. That works perfectly..
Thank you so much!!
Thanks a lot for the expression . it works perfectly fine.
But, I have 15 such attributes and having 15 calculated dimensions on the report, the performance drastically goes down...
is there any other alternative to calculated dimensions?
Thanking you in advance
Here try this formula instead, this should improve the performance a bit:
aggr(maxstring({$<Date = {'$(=rangemax(GetFieldselections(Date1), GetFieldSelections(Date2)))'}>}Attr), ID)
If you can, instead of calculated dimensions, I would use it as an expression instead, that way you can remove the aggr and just use:
maxstring({$<Date = {'$(=rangemax(GetFieldselections(Date1), GetFieldSelections(Date2)))'}>}Attr)
See if this helps at all.