topic Re: Please share any one have sample qvw using ETL(informatica)data? in QlikView

Please share any one have sample qvw using ETL(informatica)data?

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

I am going to develop the dashboard using informatica data. Present I don't know the requirement but before that I have to find out some sample dashboard are requirements and kpi S.

I am using etl data like jobs status and source count and target count. What are the jobs and workflows success run like that.any one have idea about this please share the information .

Thanks

Re: Please share any one have sample qvw using ETL(informatica)data?

Anonymous — Tue, 24 Apr 2018 06:16:40 GMT

Hi,

If you install QlikView you can have few sample available in this location

C:\Program Files\QlikView\Examples\Documents

or you can even Qlikview demo site to download more demos.

Link to Demo site

Qlik Demos: See QlikView in Action | Demo.Qlik.Com

Sample Dashboard

Re: Please share any one have sample qvw using ETL(informatica)data?

daisy1438 — Fri, 10 Aug 2018 06:30:31 GMT

Hi Aruna

could you please help on below requirement if you get any idea.

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.

Re: Please share any one have sample qvw using ETL(informatica)data?

Anil_Babu_Samineni — Fri, 10 Aug 2018 08:35:03 GMT

Can you show what you have tried in front end which is performance trouble? So, Then we will get to know what exactly presence.

Re: Please share any one have sample qvw using ETL(informatica)data?

bvssudhakar — Fri, 10 Aug 2018 10:27:02 GMT

Hi Anil These are my two expressions in my pie chart:

=Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"},[Job Status]={Closed}>} [Total No. of Openings])

=Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"},[Job Status]={Closed}>} [Ageing in days])

Can you explain how to modify them to show skillname-score like this (whatever you show in 1st chart ... Qlikview-60)

Re: Please share any one have sample qvw using ETL(informatica)data?

bvssudhakar — Fri, 10 Aug 2018 10:47:38 GMT

Hi Staffan,

I tried It's not changing.......... is there any way to write it as in expression.

And can you also suggest the solution for me that pie-chart also

Thank you in advance

Re: Please share any one have sample qvw using ETL(informatica)data?

Anonymous — Fri, 10 Aug 2018 11:22:13 GMT

Hi daisy

I implemented code in back end

LOAD *

INLINE [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

];

Left Join(data)

R1:

LOAD

Issue_ID,

Target_date,

Count(Issue_ID) as count

Resident data

Group By Issue_ID,Target_date;

in front end try below expression

=count( {< count={1} >} aggr(count( {< count={1} >} Issue_ID),Issue_ID))

find the attached App may be it useful to you

Re: Please share any one have sample qvw using ETL(informatica)data?

Anil_Babu_Samineni — Sun, 12 Aug 2018 08:11:45 GMT

I haven't shown any where, Does it come from another link - Can you share ref, Where i have to look.

And, There is no complex in set analysis and that is so straight forward of analysis. Don't think so there is any better performance can reduce.

Re: Please share any one have sample qvw using ETL(informatica)data?

daisy1438 — Thu, 16 Aug 2018 13:08:45 GMT

Hi Aruna,

thanks for your reply and I have one requirement .if you know please help me.

I am trying to above expressions. But it is not showing properly.

I am using below exp

=If(getselectedcount([Issue Location]) = 0 or getselectedcount([Issue Location])<1 ,'Issues by Geography','Issues by Region').

Actually I have two fields 1)IssueRegion 2)IssueLocation

Using both fields creating drill down and initial chart showing based on region once user click any region than chart showing the based on location(under the regions what are the location available).

By default chart showing the region wise and chart title "by region".

my requirement is when chart showing based on location and change the Chart Title "by Location"

Thanks.