Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

straight table issue

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.

6 Replies
Anonymous
Not applicable
Author

Hi

Change the expression to like this

Exp1:

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

Exp2:

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

nizamsha
Specialist II
Specialist II

= Hi  Chandini u can try this one

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

Anonymous
Not applicable
Author

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
Not applicable
Author

Hi Nijam..

Yhanks for your response..

please find following attachment..

nizamsha
Specialist II
Specialist II

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

Anonymous
Not applicable
Author

No nijam the value getting change..

thanks...