topic Re: Problem from Same Dates and values counts are showing 1 in QlikView

Problem from Same Dates and values counts are showing 1

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am facing problem with same dates having same values so I want to show my data in Table box or straight Table, in that data showing only one date with all values count. I will give you some data.

I have a data like this:

Date Values

1/2/2016. Fix

1/2/2016 Fix

1/2/2016. Fix

When I am using starlight table its shows:

Date. Values

1/2/2016. Fix

If I use count or sum express:

Date Value. Count(fix). Sum(fix)

1/2/2016. Fix. 1. 4

What I am expect results to want to show all dates and values in individual rows

Date Values Sum. Count

1/2/2016. Fix 1. 1

1/2/2016 Fix 1. 1

1/2/2016. Fix. 1. 1

1/2/2016. Fix 1. 1

Right now I am using Date field as a dimension Please guide me how to achieve this.

Regards,

Sunny

Note: Formatting edited by Community Moderator

Re: Problem from Same Dates and values counts are showing 1

swuehl — Sat, 28 May 2016 16:09:34 GMT

Load your data in using a primary key, e.g. using RowNo():

LOAD *, RowNo() as Key

INLINE [

Date, Values

1/2/2016, Fix

];

Then create a straight table chart with dimensions Key and Date and your expressions.

You can hide the Key column on presentation tab, if you want.

Re: Problem from Same Dates and values counts are showing 1

Sat, 28 May 2016 20:42:32 GMT

Thank you Swuehl its working for me.Thank you for your answer