Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

How to show uncategorised rows?

When using a table (versus a pivot table) - I have a number of rows which do not fit into my classification and they appear as a blank rows but it is valuable information.  Is there a way of showing this information in a text box?

The table is shown below. 

Also

I want to show all values - so set analysis - how do I do this with an aggr?

count(aggr((DateQA - DateCT),PatIDCreate_Date))

CaptureXX.JPG

Thank you

Jo

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

Are you looking for something like this?

2017-01-02 17_42_08-QlikView x64 - [C__Users_psd_Downloads_commnity.qlik.com - How to show uncategor.png

I have attached the QlikView app

View solution in original post

4 Replies
Anil_Babu_Samineni

I am not sure, I understand fully, Try from Show all values check of dimension, How date format seems

Try like this

Aggr(count((DateQA - DateCT),PatIDCreate_Date))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
petter
Partner - Champion III
Partner - Champion III

Are you looking for something like this?

2017-01-02 17_42_08-QlikView x64 - [C__Users_psd_Downloads_commnity.qlik.com - How to show uncategor.png

I have attached the QlikView app

josephinetedesc
Creator III
Creator III
Author

Hi ANIL


Aggr(count((DateQA - DateCT),PatIDCreate_Date))


no this did not work - I wanted something like

count({1}Aggr(count((DateQA - DateCT),PatIDCreate_Date))

???

Jo

josephinetedesc
Creator III
Creator III
Author

Thank you Petter

ok so:

the full table:     Sum(Chklist)

Classified Table: Sum( {<PathwayName={"*"}>} Chklist)

Unclassified table; Sum( {1-<PathwayName={"*"}>} Chklist)

text Object:

=Concat(

    Aggr( 

        Concat(    DISTINCT {1-<PathwayName={"*"}>} KeyQA ) & '    '    & Sum( {1-<PathwayName={"*"}>}  Chklist)

        , PathwayName // Group by PathwayName

        , PathwayNum  // and PathwayNum

        , KeyQA        // and KeyQA   

    )

    , Chr(10) // use a linefeed between the values in the textbox

    , KeyQA      // order the list by KeyQA

)

so the difference between the Classified and the Unclassified is the (1 - )  - so if I understand:

Classified Table responds to anything with a PathwayName,

but in the Unclassified table it responds to everything except those with a PathwayName.

Thank you for your help (I always find it funny that I am the one asking the question and then saying the answer is correct!     Like the pupil telling the Master - you are correct

Jo