topic sorting of data in QlikView

sorting of data

SunilChauhan — Fri, 03 Dec 2010 04:47:52 GMT

Dear alll

i have data like

product quantity price frequency

Tea 100 200 4

coffee 100 300 -

Sugar 300 - -

milk 400 200 6

hot water 500 4000 -

xyx 500 - -

i want to sort this like

product quantity price frequency

Tea 100 200 4

milk 400 200 6

Sugar 300 - -

xyx 500 - -

coffee 100 300 -

hot water 500 4000 -

please help me

Regards

Tom

sorting of data

Fri, 03 Dec 2010 04:57:58 GMT

You could create another column(called sort) and put your sort criteria in there.

sorting of data

Fri, 03 Dec 2010 09:58:26 GMT

Hello Tom,

I suppose you want to use frequency as a sorting column. It seems to that your '-' does not represent a null-value. If the empty rows are loaded with the null() it should work as you expect it.

load .... if (len(frequency) >0, frequency, null()) as frequency; ...

Regards, Roland

sorting of data

SunilChauhan — Mon, 06 Dec 2010 04:36:43 GMT

hi roland,

thanks for your kind reply.frequency is acually in cycle drill down and its not working to me.

please suggest me.

thanks

Tom

sorting of data

Mon, 06 Dec 2010 06:05:28 GMT

HI Tom,

try this,

Create a new table using inline wizard

Product SortOrder

Tea 1

milk 2

Sugar 3

xyx 4

coffee 5

hot water 6

after reload, Document Properties ->Groups->Cyclic Group -----> click on sort order button which is in bottom right hand side.

In Sort by column -> use SortOrder field as expression.

Regards,

Prabhu

sorting of data

Mon, 06 Dec 2010 10:10:11 GMT

Hello Tom,

I created I sample application with your data. Sorting of a column is independent of being in a group. And I think you don't want to sort allways in the same order (as i.e. posted above). Would you please try to describe it exactly in my app?

sorting of data

Mon, 06 Dec 2010 11:48:52 GMT

Hi Tom,

Here with I have attached the application in which way you want.Check and let me know.

Thanks & Regards

Jai

sorting of data

SunilChauhan — Thu, 09 Dec 2010 08:20:04 GMT

Dear jay ,

thanks for ur reply.

i have more products and i can give seq like this.

if u have any idea then let me know.