Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

script for having one row instead of 2 rows

Hi All,

I am developing Seconds & Scrap generation report for QM module in that i want to show from and to location code in one row

I am getting  as given below :

In above example I will get 2 rows for seconds and scrap but i want it single row.How to do it in script side.QlikTech Admin

6 Replies
sasikanth
Valued Contributor III

Re: script for having one row instead of 2 rows

HI Rupali

Its better to share a sample App of your requirement , so that you will get faster response

Not applicable

Re: script for having one row instead of 2 rows

Hi Rupali,

Reason why there are two rows is, for one particular line item the SCRAP Movement Loc To is Null/Empty.

You gotta handle this in script and some how bring PRODILRS-SCRAP value in it .. so that it will concatenate.

Regards,

Prabhu

Not applicable

Re: Re: script for having one row instead of 2 rows

Hi  sasikanth_Narne,

Please find an attachment. In that I have 2 material code and quality is there and depening upon quality i will deicde that it is in seconds or in scrap . so that's why it is in 2 rows but how to make it in single row in script side.

Not applicable

Re: Re: script for having one row instead of 2 rows

Hi sasikanth_Narne,

Please find an attachment. In that example, I have main material in that 2 sub material are there and both having different quality and depending upon quality it will appear in seconds or scrap . either it will appear in seconds or in scrap so that's why it appearing in two rows i want it in single row only from script side so how to do it.

Not applicable

Re: Re: script for having one row instead of 2 rows

HI Prabhu Pandian,

Please find above attachment.

MVP
MVP

Re: script for having one row instead of 2 rows

Hi,

You are getting Null value for one record in Scrap Movement Location To field, avoid it in the script or select Supress When Value Is Null in Dimension Tab for that field.

Hope it helps you.

Regards,

jagan.

Community Browser