topic Re: include all and at the same time include null values also.. Count({<SalesMan={"*"}& in QlikView

include all and at the same time include null values also.. Count({} Distinct PNam )

RheaQv12 — Thu, 17 Oct 2019 00:40:03 GMT

Hi there,

I have a scenario where there are nulls as part of join in the data model so i am not able to replace the nulls at the load script level... I have this scenario where the user will select the SalesMan listbox and this selection should not be applied to one of the straight table so SalesMan={*} and counting the ProductName values... * is excluding the NULL values

but there are certain ProductNames which do not have a SalesMan...so how do i get both i.e SalesMan={"*"} - this is required because i do not want to SalesMan dimension to change when the user selects the SalesMan in the listbox (the stragiht table should not change) ---not sure how to put this...

Count({<SalesMan]={null} and SalesMan]={"*"}>} Distinct PName) - something like this

thanks a lot

Re: include all and at the same time include null values also.. Count({
Arthur_Fong — Thu, 17 Oct 2019 03:48:34 GMT

Try:
Count({<SalesMan=>} Distinct PName)

Re: include all and at the same time include null values also.. Count({
RheaQv12 — Thu, 17 Oct 2019 12:30:02 GMT

Hi
thanks but this will change the data in the straight table when i select the SalesMan value in a listbox - i do not want the st table to change when a value is selected in salesman listbox
the st table with salesman as dim should not chabge thats why i was using *

Re: include all and at the same time include null values also.. Count({
sunny_talwar — Thu, 17 Oct 2019 13:21:22 GMT

This expression by @Arthur_Fong is doing exactly that... ignoring selection in SalesMan field while allowing you to see nulls
Count({<SalesMan=>} DISTINCT PName)
You can also write this without the = sign
Count({<SalesMan>} DISTINCT PName)

Re: include all and at the same time include null values also.. Count({
RheaQv12 — Thu, 17 Oct 2019 17:58:49 GMT

Thank you @Arthur_Fong and Sunny_Talwar

topic Re: include all and at the same time include null values also.. Count({<SalesMan={"*"}& in QlikView

include all and at the same time include null values also.. Count({} Distinct PNam )

Re: include all and at the same time include null values also.. Count({ Arthur_Fong — Thu, 17 Oct 2019 03:48:34 GMT Try: Count({<SalesMan=>} Distinct PName)

Re: include all and at the same time include null values also.. Count({ RheaQv12 — Thu, 17 Oct 2019 17:58:49 GMT Thank you @Arthur_Fong and Sunny_Talwar

Re: include all and at the same time include null values also.. Count({
Arthur_Fong — Thu, 17 Oct 2019 03:48:34 GMT

Try:
Count({<SalesMan=>} Distinct PName)

Re: include all and at the same time include null values also.. Count({
RheaQv12 — Thu, 17 Oct 2019 17:58:49 GMT

Thank you @Arthur_Fong and Sunny_Talwar