Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics
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
You may try something like this as dimension:
dual(
if(WildMatch([Companies], 'Company*') = 1, 'Company A', 'Company B') & ' ' & [WeekNumber],
[WeekNumber])
- Marcus
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!
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics
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
Marcus,
With that change, the Graph became the same as it was in the first picture i uploaded.
- Matheus
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics
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
Thanks Marcus!
That solved my problem!
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics