topic Re: Comparison between Total, All, 1 and $ in QlikView

Comparison between Total, All, 1 and $

kkkumar82 — Thu, 02 Apr 2015 05:48:46 GMT

Hi all,

After learning so much from the community, I would like to give back to the community something which can be useful for the beginners in set analysis understanding Identifiers $, 1 and qualifiers Total , All,

For this I have used a data set containing 20 records of employees from an excel file.

Perform some selections in the filters and observe the measure values.

I came to know the difference with "all" and "1" which you can also, just check/uncheck the property "Suppress when value is null" in the dimensions tab of chart properties and observe the values of last two measures.

one of the records is containing a null value for the field Department_id which is making the difference.

Thanks

Kiran Kumar

Re: Comparison between Total, All, 1 and $

Anonymous — Thu, 02 Apr 2015 05:55:44 GMT

Distinct can be added to this

Re: Comparison between Total, All, 1 and $

robert_mika — Thu, 02 Apr 2015 06:05:23 GMT

Move this topic to Library so more people can benefit from your work

Resource Library

Re: Comparison between Total, All, 1 and $

kkkumar82 — Thu, 02 Apr 2015 06:14:24 GMT

I tried to move it but Iam not able to see that name in "place".

Re: Comparison between Total, All, 1 and $

sujeetsingh — Thu, 02 Apr 2015 06:16:13 GMT

Need to come in more words and in defined way.