Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
sbusisochiya
Contributor II
Contributor II

qlik back end

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.

qlik quiry.PNG

5 Replies
Siva_Sankar
Master II
Master II

Hi,

Explain your requirement clearly with some sample.

How to get answers to your post?

-Siva

Anil_Babu_Samineni

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..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
avinashelite

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

sbusisochiya
Contributor II
Contributor II
Author

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

kamalqlik
Partner - Specialist
Partner - Specialist

Hi,

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

Regards

Kamal