topic Re: Help on this!! in QlikView

Help on this!!

Thu, 04 Apr 2013 06:56:11 GMT

Hi all,

can you tell me the expression to show unique data values in analysis?

Regards,

Thiru.

Re: Help on this!!

kaushiknsolanki — Thu, 04 Apr 2013 07:01:21 GMT

Hi,

Try distinct keyword in your expression.

Regards,

Kaushik Solanki

Re: Help on this!!

sushil353 — Thu, 04 Apr 2013 07:21:48 GMT

Hi,

you can use DISTINCT key word..

it is better to explain your sceanario...

HTH

Sushil

Re: Help on this!!

Thu, 04 Apr 2013 07:26:50 GMT

u can use distinct in your expression

sum(DISTINCT NET_AMOUNT)

Re: Help on this!!

prasad_dumbre — Thu, 04 Apr 2013 07:27:13 GMT

Hi Thirumalai,

Can you explain some more, as not able to find out what you exactly wants. Also mention in which chart you want this. . .

Re: Help on this!!

Thu, 04 Apr 2013 07:27:40 GMT

Hi Thiru,

Can you please share more details on your requirement. Though you can use distinct keyword in your expressions.

Thanks,

Angad

Re: Help on this!!

Thu, 04 Apr 2013 08:28:53 GMT

Hi Thiru,

i did not understand what you need exactly but maybe you can use a .distinct when you load your data. Please send an example of what you want

Re: Help on this!!

swuehl — Thu, 04 Apr 2013 08:32:19 GMT

Hi,

I am not quite clear about your requirement, so a small example (like an excel file with your input data and your requested outcome or even some data lines added to your post) might help me in understanding your issue.

If you want to see the unique data values of a field, creating a list box for that field should be enough.

If you want to count e.g. only the unique order numbers, use the distinct qualifier in your aggregation function, like

=count(DISTINCT OrderNum)

Hope this helps,

Stefan

Re: Help on this!!

Thu, 04 Apr 2013 09:56:41 GMT

Hi All,

I tried with count(distinct).it's working fine

Thanks..

Regards,

Thiru

Re: Help on this!!

Thu, 04 Apr 2013 10:00:06 GMT

Thanks all