topic Re: Sorting Text and Number in calculated Dimension in QlikView

Sorting Text and Number in calculated Dimension

Zapparoli — Sat, 16 Nov 2024 18:05:08 GMT

Hello, i'm having trouble in sorting my dimension in QlikView.

My Calculated Dimension is: =if (WildMatch([Companies], 'Company*') = 1, 'Company A', 'Company B') & ' ' & [WeekNumber]

In the attached file, you can see the result.

What i want to achieve is sorting the Week for Both company A and B for them be side by side.

Company A 17

Company B 17

Company A 18

Company B 18

etc...

I have Tried in the Order tab using WeekNumber as a expression, but it did not work.

What i could possibly do ?

Thanks in Advance.

Re: Sorting Text and Number in calculated Dimension

marcus_sommer — Mon, 21 Sep 2020 13:14:42 GMT

You may try something like this as dimension:

dual(
if(WildMatch([Companies], 'Company*') = 1, 'Company A', 'Company B') & ' ' & [WeekNumber],
[WeekNumber])

- Marcus

Re: Sorting Text and Number in calculated Dimension

Zapparoli — Mon, 21 Sep 2020 13:38:51 GMT

Hello Marcus!

That almost worked!

The values got sorted Correctly, but i can only see Company B now.

Company B 17 - Bar One: 553,23
Bar Two: 222,21

Company B 18 - Bar One: 491,16
Bar Two: 239,01.

I'm suspecting my IF condition broke somehow, but i'm not really sure.

Thanks!

Re: Sorting Text and Number in calculated Dimension

marcus_sommer — Tue, 22 Sep 2020 11:18:56 GMT

Of course, it couldn't work because I missed to set the numeric part of the dual() properly - therefore change it to:

dual(
if(WildMatch([Companies], 'Company*') = 1, 'Company A', 'Company B') & ' ' & [WeekNumber],
[WeekNumber] * 100 + if(WildMatch([Companies], 'Company*') = 1, 1, 2))

- Marcus

Re: Sorting Text and Number in calculated Dimension

Zapparoli — Thu, 24 Sep 2020 14:19:51 GMT

Marcus,

With that change, the Graph became the same as it was in the first picture i uploaded.

- Matheus

Re: Sorting Text and Number in calculated Dimension

marcus_sommer — Thu, 24 Sep 2020 14:28:00 GMT

Ok, then try it in this way:

dual(
if(WildMatch([Companies], 'Company*') = 1, 'Company A', 'Company B') & ' ' & [WeekNumber],
[WeekNumber] + if(WildMatch([Companies], 'Company*') = 1, 0.1, 0.2))

- Marcus

Re: Sorting Text and Number in calculated Dimension

Zapparoli — Fri, 25 Sep 2020 14:14:08 GMT

Thanks Marcus!

That solved my problem!