topic Searching Unique Ids from data base in QlikView

Searching Unique Ids from data base

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

Hello Guys,

I'm new developer in this qlik environment

I have stuck here....case elaborated as below...
Data contains dim1 : ID and dim2: flag which is Generated and Booked , the ID which is generated may be booked or not booked ...
I am finding only generated which is falls under flag generated and not booked one.

any help regarding is much appreciated.

Regards,
Yuva

Re: Searching Unique Ids from data base

rwunderlich — Tue, 05 Mar 2019 16:35:49 GMT

Hi,

Can you post your load script?

Can you elaborate on "finding only generated"? Where are you seeing this? In a chart, in the data model viewer?

Or do you want to load only those rows where Flag=Generated?

-Rob

Re: Searching Unique Ids from data base

Yuva — Tue, 05 Mar 2019 16:42:27 GMT

Hello,
Need to show generated ids in straight table not chart...

Re: Searching Unique Ids from data base

rwunderlich — Tue, 05 Mar 2019 23:10:01 GMT

Do you mean you want to show only Flag=Generated in the table?

-Rob

Re: Searching Unique Ids from data base

Yuva — Wed, 06 Mar 2019 06:38:23 GMT

Hi Rob
Thanks for your reply.
Yes, only Generated ids wants to show in to field (Table) and which not falls under booked flag .

Regards,
Yuva

Re: Searching Unique Ids from data base

Yuva — Wed, 06 Mar 2019 07:08:50 GMT

Dear Rob
Yesterday's Generated id's which is highlighted in yellow only those I want to show in table.
Please refer the attached file for more details.

Thank you.

Re: Searching Unique Ids from data base

Sue_Macaluso — Wed, 06 Mar 2019 13:34:14 GMT

Hi, Are you referring to QlikView or Sense? I would like to move this post into the product forum. Thanks

Re: Searching Unique Ids from data base

rwunderlich — Wed, 06 Mar 2019 14:38:52 GMT

The set to select just those rows would be:

{<Flag={'Generated'}, Date={'$(=Date(today(2)-1))'}

So as a dimension in your table:

=aggr(only({<Flag={'Generated'}, Date={'$(=Date(today(2)-1))'}>}IDs), IDs)

or as a count in a KPI:

count({<Flag={'Generated'}, Date={'$(=Date(today(2)-1))'}>}IDs)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com