topic Re: Data Sorting in QlikView

Data Sorting

Thu, 09 Apr 2015 08:26:26 GMT

Dear all,

I'm new in qlikview. Please help me to solve my problem. My below chart is based on ascending to descending on numeric value. But my requirement is char will be display like this .. In left side AD1-3, AD4-7, AD8-10, AD16-21, AD22-30 and in middle "On Time" and in right side 1-3, 4-7, 22-30... Please help me..

Regards,

Masba

Re: Data Sorting

robert_mika — Thu, 09 Apr 2015 08:32:32 GMT

Could you post your app or data?

You can use Dual function in load script to sort the data in the way you want.

Check here:

How to use- Dual()

Re: Data Sorting

nagarjuna_kotha — Thu, 09 Apr 2015 08:41:08 GMT

Hi Masba,

To solve this problem use WILDMATCH() Function in Sort Tab .

Example :

=WILDMATCH(Region,'EAST','South','West','North')

I hope this will work as per my knowledge ....Try this

Regards,

Nagarjuna

Re: Data Sorting

Anonymous — Thu, 09 Apr 2015 08:44:25 GMT

there are two ways:

1) in sort tab you could use expression and define

if mydim='AD1-3,1,

if mydim='AD4-7',2

if mydim='OnTIme', x,

2) provide an inline table with

Load * inline [

mydim, sorttab

'AD1-3', 1

'AD4-7', 2

then add to tab sort the expression "sorttab" ascending

hope that helps

Re: Data Sorting

anbu1984 — Thu, 09 Apr 2015 08:46:24 GMT

Use the below expr in Sort tab and uncheck other than "Expression" in Sort by

Match(DimensionName,'AD1-3','AD4-7',...)

Add the values of the dimension to the above expr in the order you want to display in Bar chart

Re: Data Sorting

Thu, 09 Apr 2015 08:54:57 GMT

Dear Robert,

For your better understanding please find attachment..

Regards,

Masba

Re: Data Sorting

anbu1984 — Thu, 09 Apr 2015 10:12:26 GMT

Check this app

Re: Data Sorting

Thu, 09 Apr 2015 10:48:32 GMT

Dear Anbu,,

Thanks for your reply.. In my apps, Dimension is one calculative dimension that is

=If (PO_Ex_Factory_Date-PO_DATE<=-30,'A30+',

If (PO_Ex_Factory_Date-PO_DATE<=-22,'A22-30',

If (PO_Ex_Factory_Date-PO_DATE<=-16,'A16-21',

If (PO_Ex_Factory_Date-PO_DATE<=-11,'A11-15',

If (PO_Ex_Factory_Date-PO_DATE<=-8,'A8-10',

If (PO_Ex_Factory_Date-PO_DATE<=-4,'A4-7',

If (PO_Ex_Factory_Date-PO_DATE<=-1,'A1-3',

if(PO_Ex_Factory_Date-PO_DATE=0, 'Duetime',

If (PO_Ex_Factory_Date-PO_DATE <=3, 'L1-3',

If (PO_Ex_Factory_Date-PO_DATE<=7, 'L4-7',

If (PO_Ex_Factory_Date-PO_DATE<=10, 'L8-10',

If(PO_Ex_Factory_Date-PO_DATE<=15, 'L11-15',

If (PO_Ex_Factory_Date-PO_DATE<=21, 'L16-21',

If (PO_Ex_Factory_Date-PO_DATE<=30, 'L22-30',

If (PO_Ex_Factory_Date-PO_DATE>=30, 'L30+')))))))))))))))

So how can i add this Sort Tab.. Please advise me..

Re: Data Sorting

Anonymous — Thu, 09 Apr 2015 11:01:29 GMT

This calculated dimension is okay, when you just want to test if the calculation is working.

drawbacks are, that you cannot easily define a sort table unless you make a similiar expression in the sort tab

and - which might not be a problem in your case - it takes time to calculate and it is not easy to read

my suggestion is to put this part in script and provide an extradatafield which you can use insetad of this calculated dimension. also you can put a sort field in script which would solve your problem.

you might solve your problem in the way you started it, but it is not a solution I would recommend!

Re: Data Sorting

sunilkumarqv — Thu, 09 Apr 2015 12:20:54 GMT

@Hi Masaba,

please find the attached

use of dual you can make sort order

Re: Data Sorting

Sun, 12 Apr 2015 08:27:44 GMT

Dear Sunil,

Thanks a lot for your solution. My problem is solve..

Regards,

Masba