set analysis

prrajendran — Sat, 16 Nov 2024 02:07:45 GMT

Hi Experts,

i have a table with Date, 15 Min Interval time, product no, ID & Name in my qvw.

Sample Input data in excel sheet attached :

i have to provide a grouped result for a day at 15 min intervals like the output in the attached excel sheet. i have to find how many singles(Product no with 1 Product detail), doubles & triples in a day

But i have to exclude 'N/A' in the 'Product Details' field for my grouped result.

Each Product No will have multiple Product details associated with it. for example, in the above table, for 09/10/2019 at 12:00:00, there are 3 products with the same product no. so my result for 12:00:00 should be

Date 15 Min Interval Single Double Triple

09/10/2019 12:00:00 0 0 1

similarly, at 00:30:00, 3 products with product no SA711, but 2 of them shows N/A in product details. so i have to exclude that 2. my result at 00:30:00 should be

Date 15 Min Interval Single Double Triple

09/10/2019 00:30:00 1 0 0

so My entire output for the above table should be like the one in the attached file

I have attached the input and output data in excel.

Can you please help me with the expression to get this result?

topic Re: set analysis in QlikView

set analysis

Re: set analysis