topic Re: pivot and straight Table in QlikView

pivot and straight Table

Mon, 19 Jan 2015 11:19:36 GMT

Hi,

How to display all the records by using Input box like Top 10, 20,30 ... in straight and pivot table.

Can you please tell me .

Thanks,

MLNR

Re: pivot and straight Table

PrashantSangle — Mon, 19 Jan 2015 11:23:23 GMT

Hi,

Create Variable,

then

1) If you are using Straight table then go to Dimension limit

select show only->and insert variable name in front of it.

2) if you are using Pivot table

then in dimension use Calculated dimension and in that use rank()

Regards

Re: pivot and straight Table

arulsettu — Mon, 19 Jan 2015 11:25:14 GMT

check this

Calculating TOP 10 VALUES in PIVOT TABLE

Re: pivot and straight Table

Mon, 19 Jan 2015 11:31:17 GMT

Hi,

Now i created variable and pass that variable to input box and straight and pivot Table. so i got Top 10,20,30..... like that. along with that i want to display All the records.

How can i achieve this.

Thanks,

MLNR

Re: pivot and straight Table

Mon, 19 Jan 2015 11:33:54 GMT

Hi,

Hope you mean to control the Top Records to be listed using Input Box.

Use the Following Steps :

1. Create a Variable.

2. Create an Input Box and assign the Variable to it.

3. Create your Chart as desired.

4. Go to the Dimension Limits Tab in the chart and check the Limits Check Box and the First radio Button -Show Only.

5. Assign your Variable in place of Values.

You can also control the Input Box values to be entered.

Hope it helps !

Cheers !

Re: pivot and straight Table

Mon, 19 Jan 2015 11:45:49 GMT

Hi ,

This is ok. I achieved,

to control the Top Records to be listed using Input Box. and along with that if user wants to display all the records.

what is process for that,

Thanks,

MLNR

Re: pivot and straight Table

Mon, 19 Jan 2015 11:47:01 GMT

Hi,

To control the Top Records to be listed using Input Box. and along with that if user wants to display all the records.

what is process for that.

Thanks,

MLNR

Re: pivot and straight Table

PrashantSangle — Mon, 19 Jan 2015 11:58:06 GMT

Hi,

Try like

Create One more chart containing all records and using Conditional layout hide or show those report

try condional like

if (isNull(variable),chart1,chart2)

Regards

Re: pivot and straight Table

Mon, 19 Jan 2015 12:05:33 GMT

Hi,

Put a condition in the Dimenstions Limit like this ;

( vVar='' ,Count({$< Field_Name >}distinct Field_Name ),vVar)

When your Input Box is Null / Empty, this condition will let all the data to pop up in the Chart.

Make sure you uncheck the 'Others' checkbox.

Hope it helps!

Cheers !