topic Re: multi values in single column in QlikView

multi values in single column

arulsettu — Fri, 24 Apr 2015 08:36:05 GMT

i am having currency in three country format

ex:

amount_1 - is india

amount_2 -is us dollar

amount_3 -is euro

now i need to show like this in pivot or straight table

Account_num amount

1100 20000 rs

333 $

259 Euro

1101 30000 rs

433 $

359 Euro

any one plz suggest some advice how to achieve this

thanks

Re: multi values in single column

arulsettu — Fri, 24 Apr 2015 08:48:48 GMT

any help guys?

Re: multi values in single column

anbu1984 — Fri, 24 Apr 2015 08:48:50 GMT

Can you post sample input?

In input, do you have three rows for each account?

Re: multi values in single column

arulsettu — Fri, 24 Apr 2015 08:55:31 GMT

hi Anbu,

i am having amount in three different fields for each account i am having amount in three formats

amount_1 - is india

amount_2 -is us dollar

amount_3 -is euro

Re: multi values in single column

jagan — Fri, 24 Apr 2015 08:57:22 GMT

Hi,

Attach some sample data which you have so that it would be easier to provide the solution.

Regards,

Jagan.

Re: multi values in single column

arulsettu — Fri, 24 Apr 2015 08:58:47 GMT

here is the sample data

Re: multi values in single column

arulsettu — Fri, 24 Apr 2015 08:59:41 GMT

Hi Jagan,

check above sample data

thanks

Re: multi values in single column

Fri, 24 Apr 2015 09:01:24 GMT

Hi Arul,

have a look at using crosstable() to convert those three fields into a single field, you'll then have three rows one for each of the currencies

see attached

Hope that helps

Joe

Re: multi values in single column

jagan — Fri, 24 Apr 2015 09:01:44 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: multi values in single column

anbu1984 — Fri, 24 Apr 2015 09:03:56 GMT

Check this app

Re: multi values in single column

arulsettu — Fri, 24 Apr 2015 09:07:34 GMT

can you plz explain how u do that?

Re: multi values in single column

Fri, 24 Apr 2015 09:07:54 GMT

hi,

Arul . from your question, if you want to show 3 currency in pivot table you can make a table

fact_color:

LOAD * INLINE [

amount, value

amount_1, india

amount_2, us dollar

amount_3, uero

];

then after reload in pivot table set amount as dimension and value as expression.

hope this can help you;

Re: multi values in single column

jagan — Fri, 24 Apr 2015 09:49:48 GMT

Hi,

I have created 3 expressions and formatted the numbers in Number tab. Please check.

Regards,

Jagan.