topic Re: Generic load alternative in QlikView

Generic load alternative

Mon, 10 Aug 2015 11:02:31 GMT

Hello community, i have i a problem with a table, here is the table following by what i want :

Current Table (iQlikview table that i export to excel) :

What i want :

i want two table or one big table (i slipt it for presentation purpose).

My solution was to do a generic load, but in my case i have more that one attribuate field ( [Pose /Dépose], ETI and Nature,)

Someone know how to to that? i joined a sample file (qvw and data).

Thanks

Anonymous — Mon, 10 Aug 2015 17:44:57 GMT

Hi,

I hope the qvw attached is ok for you.

Let me know,

Kushal_Chawda — Mon, 10 Aug 2015 18:41:40 GMT

Please see the attached

qlikviewwizard — Tue, 11 Aug 2015 02:04:59 GMT

Please close the thread by selecting Correct Answer if you got the solution. Thank you.

Tue, 11 Aug 2015 07:00:52 GMT

Hi Kush,

Your solution seem good, but i need all that field separatly not together like you did,

Thanks

Kushal_Chawda — Tue, 11 Aug 2015 07:15:36 GMT

You can do something like attached

Tue, 11 Aug 2015 07:31:01 GMT

in fact i want all field so 16 field (combinaison of pose, depose, souterrain et aerien and vert, jaune..)