Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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)))