Skip to main content
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
iahmadmca1
Contributor III

Use Group by base on TGB_Name

Team,

Just I want to take one help regarding group by TGB Name.I have listed down the below script based on this script I need to use group by TGB_Name could you please help me to do this.

Details:

LOAD OperatingDate as oprating_date,

      TGB_ID as TGBID,

     TGB_Name as TGBName,

     ENCLOSURE as Enclosure,

     ALARMS as Alarm,

     IPADDR as IPAddress,

     FIRST_ALERT as First_Alert,

     LATEST_ALERT as Latest_Alert,

     COUNTER as Counter,

     EVENT_TIME as Event_time

       FROM

(qvd) ;

Below TGB Name details.

TGB_Name

Elkview_DA (PECO_AC PECOD)

Newlinville_DA (PECO_AC PECOD)

Pools_DA (PECO_AC PECOD)

Elkview_AMI (PECO)

Newlinville_AMI (PECO)

Pools_AMI (PECO)

METER_SHOP_1733_TEST (PECOTEST)

BerwynMeterShop_AMI_TX2 (PECO)

Thanks,

Irshad Ahmad

11 Replies
iahmadmca1
Contributor III
Author

Thanks for the reply

PrashantSangle

If your issue resolve please close thread.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂