Searching Unique Ids from data base

[Yuva]

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

[rwunderlich]

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

[Yuva]

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

[rwunderlich]

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

-Rob

[Yuva]

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

[Yuva]

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.

[Sue_Macaluso]

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

[rwunderlich]

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