topic Re: straight table issue in QlikView

straight table issue

Anonymous — Thu, 27 Nov 2014 10:46:24 GMT

Hi..

I create straight table it has some values.

Please find following attachments..

in Repeat calls column initial it shows one value when i pressed perticular value it shows different value..

please help me

Thanks.

Anonymous — Thu, 27 Nov 2014 12:05:02 GMT

Change the expression to like this

Exp1:

num(count(distinct SESSIONID),'#,##0')

Exp2:

count ({<CLI={"=count(CLI)>1"}>} CLI)

nizamsha — Tue, 02 Dec 2014 09:43:48 GMT

= Hi Chandini u can try this one

sum(aggr(if(count(CLI)>1,1,0),CLI))

Anonymous — Tue, 02 Dec 2014 09:55:32 GMT

Hi,

Is there any specific reason you are using below script, instead you can use simple Count(CLI) which will resolve your issue.

Count({<CLI={"=Count(CLI)>1"}>} CLI)

Anonymous — Tue, 02 Dec 2014 11:02:21 GMT

Hi Nijam..

Yhanks for your response..

please find following attachment..

nizamsha — Tue, 02 Dec 2014 11:20:42 GMT

=sum(aggr(if(count({$<CLI=,Rep_Details=,Date=,HUB=>} CLI)>1,1,0),CLI))Try This One

Anonymous — Tue, 02 Dec 2014 11:44:52 GMT

No nijam the value getting change..

thanks...