Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

set analysis

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?

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: set analysis

1 Reply
Highlighted
Contributor III
Contributor III

Re: set analysis