Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Highlighted
pooja821
Contributor

Handling Multiple same records corresponding to one specific Employee in Qliksense

Hi,

I have some records like Date, Employee ID and there corresponding Billing amount.

So the data I have is like this:

DateEmployee IDBilling  Amount

31-May-2018

65446000
31-May-201834567899
31-May-201867897865
31-May-2018987755567
30-Jun-201823345567
30-Jun-2018654489000
30-Jun-201834567899
30-Jun-201878653000
31-Jul-201834562000
31-Jul-201834564000
31-Jul-201834565000
31-Jul-201834565000
31-Jul-201834565000

There is a case in my data for Employee ID 3456 in July month where it has three Billing Amount as 2000, 4000 and 5000.

Now the issue I m facing in qliksense is that when I am taking the Billing amount then its considering only distinct billing amount that only 2000, 4000 and only one time 5000 in spite of taking 5000 as three times i.e.

Billing amount total should come out to be like : 2000 + 4000 + 5000 + 5000 + 5000 =21000 but my result is coming out to be as 2000 + 4000 + 5000 = 11000 which is giving me wrong results.

stalwar1  Kindly help me on this. Really Urgent. Would really appreciate if you could help.

5 Replies
tomasz_tru
Valued Contributor

Re: Handling Multiple same records corresponding to one specific Employee in Qliksense

It should return correct value. Do all the columns in the same table in the data model?

Tomasz

pooja821
Contributor

Re: Handling Multiple same records corresponding to one specific Employee in Qliksense

Yes,,,these all  columns are in the same table in data model.

Re: Handling Multiple same records corresponding to one specific Employee in Qliksense

If they all come from the same table, then this should not be an issue. Would you be able to share a sample to show where you have this scenario?

gavinigovind452
New Contributor II

Re: Handling Multiple same records corresponding to one specific Employee in Qliksense

Hi team geting correct values

test.PNG

Re: Handling Multiple same records corresponding to one specific Employee in Qliksense

Super, but I am sure pooja821‌ isn't