topic Re: Straight Table repeating values in QlikView

Straight Table repeating values

Sun, 26 Jun 2016 07:27:21 GMT

Hi Guys,

I have a straight table, which is repeating values as below. How do I get the straight table without duplicates?

NOTE

I have used =1 as an expression and have kept it as a hidden expression.
I do not want to 'Suppress When Value is Null' on that field because Policy Number is an options field
So if I suppress that field then it will only show me cases where they have policy number but i want to see all the cases.
I also do not want Pivot table.

About the Data Model

@ symbol is primary keys which are hidden from users.
Each OrderID can have more then one Case ID
Each OrderID can only have none of max 1 Policy Number

Thank you.

Re: Straight Table repeating values

maxgro — Sun, 26 Jun 2016 07:39:24 GMT

Check if Order Date is a true date (without decimal); you can try this adding a listbox for Ordere Date formatted as Timestamp.

You can use the floor function to remove the time from Order Date.

Re: Straight Table repeating values

Sun, 26 Jun 2016 07:44:18 GMT

Thanks maxgro‌,

This how I am loading the order date

Date(Floor(ConvertToLocalTime(CreatedDate))) AS [Order Date]

And this is how the order date list box looks like as a timestamp

Re: Straight Table repeating values

maxgro — Sun, 26 Jun 2016 07:48:23 GMT

coukd you post your .qvw or a small extract of that with the problem?

Re: Straight Table repeating values

Sun, 26 Jun 2016 07:51:15 GMT

No worries..

Here it is..

Re: Straight Table repeating values

Anil_Babu_Samineni — Sun, 26 Jun 2016 12:13:43 GMT

Hello,

In fact, That is not possible because You have select the Case ID, Order Date --> Those Duplicate dates depend from Case ID. Two case ID's are different. Just identify that let me know.

- Anil

Re: Straight Table repeating values

Sun, 26 Jun 2016 12:17:39 GMT

Thank Anil,

Thats the thought i had since beginning but looking at the data that field (Case ID) is only repeating once in the actual table. and i could not find repeating corresponding field for that value

Re: Straight Table repeating values

Anil_Babu_Samineni — Sun, 26 Jun 2016 12:40:33 GMT

Like This..

Re: Straight Table repeating values

agni_gold — Sun, 26 Jun 2016 12:52:39 GMT

This might help

Re: Straight Table repeating values

Sun, 26 Jun 2016 13:22:01 GMT

Thank Anil, How to merge rows like this?

Re: Straight Table repeating values

Sun, 26 Jun 2016 13:22:58 GMT

Thanks Agnivesh, I will try your expression in the actual application as this is just a test data and I will update here soon.

Re: Straight Table repeating values

agni_gold — Sun, 26 Jun 2016 13:32:41 GMT

Re: Straight Table repeating values

Thu, 07 Jul 2016 07:35:49 GMT

Hi Guys I found the issue and fixed it.

The problem was in the data source.

Thank you all for your time and feedback.