Count

[raadwiptec]

I have 20 Fields on a Excel.. For Ex: These are the 3 main fields - Rest of the 17 Fields I would like to Count

DWH_Finance_ID

DWH_section

MarketID,

Count(*)

from XXX.Table

In sql i could do as above, In qlik. Please suggest

[bharatchauhan · Accepted solution]

Hi,

Try this:

Load DWH_Finance_ID

DWH_section

MarketID,

Count(F1&F2&F3.....&F17)

From Table
Group by 

DWH_Finance_ID

DWH_section

MarketID;

Please feel free to ask.
Give a thumbs up if this helped 🙂