Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community,
I'm trying to integrate a top X pivot table which only shows the top amounts based on the variable set for the limit.
I know I have to use a calculated dimension with aggr and rank - similar to this one:
=IF (aggr(rank( sum(Quantity) ,0) , Productname )<= 5 , Productname )
in my case, "Quantity" is a variable for Amount that looks like this:
vEurAmount:
=if(NOT Wildmatch(InvoiceCurrency,'EUR'), (Amount / (1 * ECBrate)),Amount)
So when I insert vEurAmount I get an: "Error: Garbage after expression: "EUR" "
How can I solve this issue?
Thank you,
Thorsten
Thorsten,
See a doc by Oleg Troyansky : http://community.qlik.com/docs/DOC-5187
I have seen it but not time to read/understand it
It can give you clue for what you want to do
Fabrice
Hello,
I know that this topic is solved and old, but for others who come here, i will show you how i did solve my problem with this error:
i just surrounded my variable with chr(39), the ASCII code for a '
eg: $(=Chr(39) & GetFieldSelections(ENSEIGNE_MAGASIN) & Chr(39))
Then Qlikview understand that it is a character string.
Good evening friends
I am facing a problem and I need your help
I try to display the first 10 sales per country in a Pivot table
so I added this expression in dimensions
and as a result I have
as you can see for 2010 it gives a result USA-> France-> germany and the logical order and it
USA-> France-> UK why?
Thank you for your answers