I have a pivot table and I am trying to count and summerized the number of records by desk per country.
Please assist i am new to qlik view.
What is the expected output here?
Do you want count like this !!!!???
TDesk count country
FQ 1 INDIA
FX 2 INDIA
My Expected Output
May be this:
Also is it possible to to merge trader ans separate by comma ',' ..
1) Concat(DISTINCT Trader, ', ')
2) Count(DISTINCT TDesk)
I tried to use the expression but its giving error
Concat(DISTINCT Trader, ', ')
Not sure why.
Can you please attached the example qvw for my refrence.
try this ?
this function will only work if "Country" is selected
=if(Aggr(Sum(1), Country)>0, 'Selected: $(=Concat(DISTINCT Trader, ', '))', ' ' )
Are you trying to use Concat(DISTINCT Trader, ',') as an expression or dimension? What is the exact error you are getting?
I tried it by using in load script as well as in dimension and got Invalid Expression.
For dimension, try this:
Aggr(Concat(DISTINCT Trader, ','), Country, TDesk)
Is it possible to do this at the time of loading data?
May be like this:
Concat(DISTINCT Trader, ', ') as Trader
Group By Country, TDesk;
Retrieving data ...