Nested for loop in qlik view

Razwan_S · ‎2022-10-03

Hi

I want to ask the community for some help using qlik view with regards to nested for statements

For example if I have a DB list I have passed into qlik view as :

123456,

54321,

123456,

66789,

1090,

54321

how can I use a nested for in qlik view to look at a if at a time and get the count, there are two ids of 123456 for example

thanks and I look forward to your replies

kind regards

rwunderlich · ‎2022-10-04

You would generally not use a loop to calculate this, but rather a Group By in script or a Dimension in a chart.

In script:

LOAD Id, Count(Id) as IdCount
from...
Group By Id;

In a chart:

Dimension: ID
Measure: Count(ID)