topic Re: straight table in QlikView

straight table

prma7799 — Thu, 11 Dec 2014 11:02:42 GMT

Hi Experts,

Is it possible in straight table to show top 25 to 50 customers.

Thanks,

Prashant

Re: straight table

jyothish8807 — Thu, 11 Dec 2014 11:05:24 GMT

Yes it is possible.

Try in dimension,

if(Aggr(Rank(Sum(Sales)),Customer)>=25 and Aggr(Rank(Sum(Sales)),Customer)<=50 ,Customer)

in expression:

Sum(Sales)

This is just an example.

Regards

Re: straight table

its_anandrjs — Thu, 11 Dec 2014 11:05:49 GMT

Hi,

Yes try the expression as calculated dimension or add the rowno90 field in the load script

RowNo(0 as row count

In chart

If( RowNo() >= 25 and Rowno() <= 50, [Customer Name])

Regards

Anand

Re: straight table

rajeshvaswani77 — Thu, 11 Dec 2014 11:09:39 GMT

have expression in sort and then use dimension limits.

thanks,

Rajesh Vaswani

Re: straight table

prma7799 — Thu, 11 Dec 2014 11:36:24 GMT

Anand

I didn't get you ...

suppose I have data like below

LOAD * INLINE [

Empl, Sales

1, 10

2, 20

3, 30

4, 40

5, 50

6, 60

7, 70

8, 80

9,90

10,100

];

and I want to see 3 to 8 empl in straight table.

Thanks

Prashant

Re: straight table

jyothish8807 — Thu, 11 Dec 2014 11:54:40 GMT

try like this,

in Calculated Dimension:

if(EmpI>=3 and EmpI<=8,EmpI)

In Exp:

Sum(Sales)

Regards

Re: straight table

amit_saini — Thu, 11 Dec 2014 11:56:43 GMT

Hi,

Check this.

Thanks,

Re: straight table

Anonymous — Thu, 11 Dec 2014 12:09:30 GMT

Hi,

If you have two limits(Lower & Upper) use rank function like below:

Dimension Tab - Add Calculated dimension:

if(Aggr(Rank(Sum(Sales)),Empl)>=3 and Aggr(Rank(Sum(Sales)),Empl)<=8 ,Empl)

Expression Tab - Add new Expression:

Sum(Sales)

For only one limit(Upper or Lower) use Dimension limits tab:

Regards

Neetha