topic qlik back end in QlikView

qlik back end

sbusisochiya — Wed, 25 Nov 2020 16:16:04 GMT

Hi Qlik Engineers.

kindly refer to the bellow attach snap short.

I'm trying to get Year,Months and Estimates Version as fields. i have attempted cross table functions but it doesn't give the necessary requirement.

please advice and thanks in advance.

Re: qlik back end

Siva_Sankar — Tue, 02 Jan 2018 03:43:30 GMT

Hi,

Explain your requirement clearly with some sample.

How to get answers to your post?

-Siva

Re: qlik back end

Anil_Babu_Samineni — Tue, 02 Jan 2018 05:12:11 GMT

I think, Pivot can plot over Cell Wrap text only like in excel. Not, Every cell. To work over that you may move into RowNo() as Dimension and drag to the row from column on top of Year to get into work..

Re: qlik back end

avinashelite — Tue, 02 Jan 2018 05:51:22 GMT

Could elaborate your desired output ? and what exactly your looking for

Re: qlik back end

sbusisochiya — Tue, 02 Jan 2018 06:48:51 GMT

Hi there,

If you look into that table, you could see that year, month is in one

field. Now I want to separate them, have month field with moths attributes

as well as year.

If I try cross table, it returns wrong values

Thanks, hope this will make sense

Re: qlik back end

kamalqlik — Tue, 02 Jan 2018 07:52:58 GMT

Hi,

Can you please share more information or data so that we can provide you desired output.

Regards

Kamal