Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bijay_jha
Creator
Creator

Diff between All, Total & Count

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

ABC.jpg

5 Replies
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bijay_jha
Creator
Creator
Author

Hi Anil,

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

Anil_Babu_Samineni

Save the data in CSV and Upload may be?

Just to know is that is question / information?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bijay_jha
Creator
Creator
Author

Please find the attachment.

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

bijay_jha
Creator
Creator
Author

Did you find the answer Anil ?

Test 2.jpgi

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