topic Re: Reports in QlikView

Reports

anjali0108 — Tue, 06 Jun 2017 12:59:37 GMT

Hi All,

I need help in one logic.

I have two excels let's say A and B where I have similar data and similar columns namely :

1. System Name

2.Tags

3.Last Communication

4.DAT Version

Now,column "Tags" is further subdivided as "Server and Workstation".

Also,for a particular date (i.e Last Communication ) ,for server we have to take rows with 'DAT Version' from n to n-2 as one report

and for workstation ,it should be from n to n-5.

I have to club these values as one report and rest as other report.

Have already tried some alternative but need some more help in completing logic for both.

I was trying rank but it was not giving me correct results.

For Example,

For any particular date,

>> Need to club the "system names" which have tags containing "Workstation" and "DAT Version" containing values n,n-1,n-2,n-3,n-4 and n-5 where n is the maximum value of "DAT Version" for that particular day.

For any particular date,

>> Need to club the "system names" which have tags containing "Server" and "DAT Version" containing values n,n-1,n-2 where n is the maximum value of "DAT Version" for that particular day.

This will be my 1st report and rest of the values should fall in other report.

Thanks in advance.

Re: Reports

vinieme12 — Tue, 06 Jun 2017 14:13:36 GMT

can you also post expected output for the given sample?

Re: Reports

tajmohamed30 — Tue, 06 Jun 2017 14:25:39 GMT

have you tried set analysis to build the logic

Re: Reports

felipedl — Tue, 06 Jun 2017 15:43:18 GMT

Hi Anjali,

Attached a QVW with formulas as to what I understood from your problem with the data you provided.

Regards,

Felipe.

Re: Reports

anjali0108 — Wed, 07 Jun 2017 05:50:49 GMT

Hi Felip,

Thanks a ton for taking out time for this.

But this is not the output I am expecting.

I am using this expression to make first report:

=If(Rank(max([DAT Version (VirusScan Enterprise)])) <=3 , [DAT Version (VirusScan Enterprise)])

and restricting top 5 values of DAT Version in dimension limits(FOR WORKSTATION) but that not able to merge server data in this.

PFB: EXPECTED OUTPUT

The above table should also contain 3 more rows with top 3 DAT Version for server as well for each date.

And the rest of the data should be there in other excel.

That's how I have to make 2 separate reports.

Hope you understand.