Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can I print the result of a script to the screen

Hi all,

I have a script looking for late approved cases, when I present the result on a chart I get another result then expected.

if(date#([Due date], 'MMM DD, YYYY') < date#([QA Approval date], 'MMM DD, YYYY'), 1, 0) as LateApprovedNC,

How can I print all the "hits" on the screen?

Can I somehow debug and see exactly why it do not comeup with the result I expect?

Thanks

Peter

1 Solution

Accepted Solutions
richard_chilvers
Specialist
Specialist

Hi

I find it useful to build a table object with all the fields that I'm interested in.

If you make LateApprovedNC a select field, you can see which combination of fields in your table give this field the value of 0 or 1.

HTH

View solution in original post

6 Replies
Not applicable
Author

Hi Peter,

Do you need count of LateApproved Cases?

If yes, please use set analysis..

richard_chilvers
Specialist
Specialist

Hi

I find it useful to build a table object with all the fields that I'm interested in.

If you make LateApprovedNC a select field, you can see which combination of fields in your table give this field the value of 0 or 1.

HTH

vardhancse
Specialist III
Specialist III

in chart the expression will be based on some dimension of the chart.

So if we use the same expression in the text object result will vary

jagan
Luminary Alumni
Luminary Alumni

Hi,

You can save the table to a csv using the STORE command like below

QVTableName:

LOAD

*

FROM DataSource;

store QlikviewTableName into myfile.txt (txt);

If you are using Table box you may not get the exact records, because it removes the duplicate records.

To display all the rows in Table box use below script, and mandatorily use the RowNum column in your table.

QVTableName:

LOAD

RowNo() AS RowNum,

*

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Anonymous
Not applicable
Author

I have changed the script so it can look if the case is late approved and if a revised date have been agreed then this is used as "new" due date"

 

if([Revised due date]='', if(date#([Due date], 'MMM DD, YYYY') < date#([QA Approval date], 'MMM DD, YYYY'), 1, 0), if(date#([Revised due date], 'MMM DD, YYYY') < date#([QA Approval date], 'MMM DD, YYYY'), 1, 0)) as LateApprovedNC,

Below is an example how it should count

Due date            Revised due date     QA Approved date     Outcome

Jan 1, 2015        Jan 30, 2015             Jan 25, 2015              No not count

Jan 1, 2015                                          Jan 25, 2015             Do count

Jan 1, 2015        Jan 30, 2015              Feb 2, 2015              Do count

Anonymous
Not applicable
Author

Hi Pooja,

Yes I need to count the late cases.

How would the "set analysis" look like, could you show an example and how it is read?

Thanks

Peter