topic Re: sorting if statement criteria within a pivot chart in QlikView

sorting if statement criteria within a pivot chart

Anonymous — Fri, 27 May 2016 08:04:33 GMT

Hi,

the first dimension within my Pivot Chart dimension

is Account, the second reads like this:-

=If(WildMatch(Code, '*WALL*'), 'Wall Paper',
If(WildMatch(Code, '*PAINT*'), 'Paint',
If(WildMatch(Code, '*NAT*'), 'Natural',' ' )))

the Count "quantity" is in the Dimension.

so my chart looks like this:-

WallPaper Paint Natural

Account A 10 0 6

Account B 9 5 2

I would like the sort order to be Natural, WallPaper, Paint.

Where do i do this?

I have tried an Aggr function in the sort function with no luck. Any help appreciated.

CELAMBARASAN — Fri, 27 May 2016 08:36:02 GMT

Use Sort by Expression - Sort order ascending

Expression as WildMatch(Code, '*NAT*','*PAINT*','*WALL*')

sunny_talwar — Fri, 27 May 2016 08:49:32 GMT

Or you can change your calculated dimension to this:

=If(WildMatch(Code, '*WALL*'), Dual('Wall Paper', 2),

If(WildMatch(Code, '*PAINT*'), Dual('Paint', 3),

If(WildMatch(Code, '*NAT*'), Dual('Natural', 1), Dual(' ', 4))))

Kushal_Chawda — Fri, 27 May 2016 08:55:12 GMT

create the conditions using dual function

If(WildMatch(Code, '*WALL*'), dual('Wall Paper',3),

If(WildMatch(Code, '*PAINT*'), dual('Paint',2),

If(WildMatch(Code, '*NAT*'), dual('Natural',1),' ' )))

sunny_talwar — Fri, 27 May 2016 08:56:34 GMT

Oye cheating kar raha hun tu meri

Kushal_Chawda — Fri, 27 May 2016 09:02:28 GMT

Nahi..muje type karne me 5 min ka time lagta.. mene dekh hi nahi tu already dala he

Kushal_Chawda — Fri, 27 May 2016 09:05:31 GMT

Notepad me code likhta me

sunny_talwar — Fri, 27 May 2016 09:08:31 GMT

Why notepad?

Kushal_Chawda — Fri, 27 May 2016 09:26:49 GMT

QlikView nahi he na... or koi option he kya?