Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I am facing problem with bifurcation of a column and the data values remains the same. Just as an example, if I have different country names under one column and with certain sales revenue. How would I show it in qlik sense graphs as single country name with its respective value. Data is somewhat like below:
Country Name | Sales Revenue |
Argentina; Australia; Austria; Belgium; Brazil; Canada; Chile | £1,256 |
Portugal; Romania; Russian Federation; Serbia; Singapore | £246 |
Ireland; Israel; Italy; Japan; Korea, Republic of; Lithuania; Malaysia; Mexico | £852 |
Egypt; Estonia; Finland; France; Germany; Greece; Hong Kong; Hungary | £2,669 |
Switzerland; Taiwan; Thailand; Ukraine; United Kingdom; United States | £822 |
Netherlands; New Zealand; Norway; Peru; Philippines; Poland | £25 |
China; Colombia; Croatia; Czechia; Denmark | £6,852 |
Please suggest.
Regards,
Arvind
Do use Above with something like this,
Trim(subfield([Country Name],';')) as [Country Name]