Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
HirisH_V7
Honored Contributor

Re: Limitation of Rows in simple Table

Check out attached using,

Expression like this:

If(GetSelectedCount(Date)>=1,
If(Rank(Sum({$<Date={"*2018"}>}Sales))<=$(TopCustomer),Sum({$<Date={"*2018"}>}Sales)),
Sum({$<Date={"*2018"}>}Sales))

Show Column:

Sum(Total {$<Date={"*2018"}>}Sales)>0

PFA for Ref.

HirisH
“Aspire to Inspire before we Expire!”

View solution in original post

canerkan
New Contributor III

Re: Limitation of Rows in simple Table

Hi Hirish7,

 

that's great! Thank you very much!! That helped me a lot.

 

I am just curious, do you think it would be possible without hiding the other columns?

HirisH_V7
Honored Contributor

Re: Limitation of Rows in simple Table

You can remove show conditional for all.. expression.
HirisH
“Aspire to Inspire before we Expire!”
canerkan
New Contributor III

Re: Limitation of Rows in simple Table

Ok, thanks!