topic Re: How to do the below requirement? in QlikView

How to do the below requirement?

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

I have two tables like table1 and table2.

Table1 having workflowname field and table2 having workflow name and Alis name field.

My requirement is which workflow name having alias name need show alias name or if alias name not available it showing workflow name only.

Like below

Work flowname. Aliasname

Wk100 wk100

Wk200 Wk200

Wk300 ABC

Wk400. DDD

Above table wk100 and wk200 not having aliasname .So aliasname also display workflow name.

Wk300 and wk400 having aliasname .so it displays aliasname.

How to do this chart level and script level.

Thanks

Re: How to do the below requirement?

poojashribanger — Thu, 31 May 2018 10:51:36 GMT

you can use MapSubString('table_name',column_name)

Re: How to do the below requirement?

Anonymous — Thu, 31 May 2018 11:40:16 GMT

in the back end use the following code,

if(isnull(Aliasname), [Work flowname], Aliasname) as [Aliasname]

What its doing is checking if Aliasname is blank or null and then replacing the null with Work flowname if its not null then dont change in field Aliasname

Re: How to do the below requirement?

gkcchowdary — Wed, 08 Aug 2018 10:03:27 GMT

Hi Alexander if get any idea on below requirement please help on this.

I want do in back end level(script)

target date changed count the ID's.

I have table fields

table:

Issu_ID

date_upload

Taget_date

-> KPI chart if the user selects any two dates compare those two dates.if maximum date and maximum previous dates in the Taget_date field are different then caluclate the count id's.

Example:

Issue_ID Date_upload Target_date

01 01-01-2018 10-05-2018

01 03-01-2018 15-05-2018

02 01-01-2018 10-05-2018

02 03-01-2018 10-05-2018

03 01-01-2018 10-05-2018

03 03-01-2018 16-05-2018

In the above table if we select dates in the date upload field i.e., 01-01-2018 and 03-01-2018 then count is 2 because id 01,03 target dates are changed and id 02 target dates are not changed.

so just count the Issues_ID when user select any two dates(ex:01-01-2018 is min date and 03-01-2018 is max date)compare those two dates if min date targetdate is onedate and max date targetdate is change to another date than caliculate the Issues_ID count.

I need quires for the above requirements in the back-end level.and write the expression front end level also if any simple way.

I have written quires in the front end level but the performance is slow and it is showing an error in the chart i.e., time out.

Thanking you.