Re: Diff between All, Total & Count - Qlik Community

Anonymous · ‎2017-08-03

Dear All,

While creating dashboard I had understood some important concepts of Qlik View,

So I wanted to share with you all. Hope it will worth to you.

Thanks

Anil_Babu_Samineni · ‎2017-08-03

Rather creating Thread and i would recommend to create Document and update those in version level

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

Anonymous · ‎2017-08-03

Hi Anil,

Total count of data is 13 Lakhs, so it crosses the limit to upload the data.

Anil_Babu_Samineni · ‎2017-08-03

Save the data in CSV and Upload may be?

Just to know is that is question / information?

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

Anonymous · ‎2017-08-03

Please find the attachment.

And try to do the same I have done it on Excel.

Anonymous · ‎2017-08-04

Did you find the answer Anil ?

i

Dimension : Region

Total Nbr : Count(GID3)

Duplicate Sit: Count(GID3)-Count(DISTINCT GID3)

Duplicate % : =(Count(GID3)-Count(DISTINCT GID3))/((count(TOTAL {<Region>} GID3)-count( DISTINCT TOTAL {<Region >} GID3)))