Use CrossTable approach.
FinalData: CrossTable('Attribute Name', '# Recordcount with NULL') LOAD Data, "Column 1", "Column 2", "Column 3", "Column 4", "Column 5", "Column 6", "Column 7", "Column 8", "Column 9", "Column 10", "Column 11", "Column 12", "Column 13", "Column 14", "Column 15", "Column 16" FROM [lib://mydata/crosstable.xlsx] (ooxml, embedded labels, table is Sheet1); drop Field [Data];
crosstable.xlsx 8.7 K
Thank you Naresh! I could transpose it now. But however, i could not the required output i.e. the counts
In the sample data that i provided i had count of rows. But when i connect to database and extract the data into Qliksense and used it on the chart I am getting everything as 0.
This is what I hv followed
//Connect to database using the connection string
//Output table name:
//Cross table logic as described in your post
// Load and listed all the columns from my database for which I wanted to know NULL counts
// SQL Script to populate the data from database.
Once the data load is complete. I tried creating a Table chart with Attribute Name and # Record count with NULL as my column names. When i did I got 0. But I am expecting to see the count of records that has NULL for column 1 , column 2 etc.
Test your output using your usual load statement.
Once you confirmed the NULL counts, and column names are appearing as in your excel sheet.
CrossTable ([Attribute Name], [# Recordcount with NULL]) Load *
Resident <your Table>
Compare both <your Table> and <NewData> in table viewer or in actual visualization (straight table)