topic Re: How to show uncategorised rows? in QlikView

How to show uncategorised rows?

josephinetedesc — Mon, 02 Jan 2017 11:15:52 GMT

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))

Thank you

Re: How to show uncategorised rows?

Anil_Babu_Samineni — Mon, 02 Jan 2017 11:33:20 GMT

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))

Re: How to show uncategorised rows?

petter — Mon, 02 Jan 2017 16:44:31 GMT

Are you looking for something like this?

I have attached the QlikView app

Re: How to show uncategorised rows?

josephinetedesc — Tue, 03 Jan 2017 02:24:31 GMT

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))

???

Re: How to show uncategorised rows?

josephinetedesc — Tue, 03 Jan 2017 02:36:06 GMT

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