Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlixperts,
I have a straight table with two dimensions
Source = 'H'
KPI = ValueList('a','b','c','d','e','f','g','h','i','j','k','l','m')
So my Dimensions looks like below
Source | KPI |
H | a |
H | b |
H | c |
H | d |
H | e |
H | f |
H | g |
H | h |
H | i |
H | j |
H | k |
H | l |
H | m |
Now i want to achieve the dimensions as below
Source | KPI |
H | a |
H | b |
H | c |
H | d |
H | e |
H | f |
H | g |
H/H | h |
H | i |
I | j |
H | k |
I/H | l |
H/I | m |
Thanks a lot in advance.
I have attached a sample qvw
May be this?
=Pick(Match(KPI,'h','i','m')+1,Source,'H/H','I/H','H/I')
Hi Anil,
Since the Fields Source and KPI is not from data model the pick and match is not working as expected
See this post
Partial Sums in straight table | Custom Labels in Pivot SubTotals
what is logic to get the dimension value as expected?
I just attached a sample qlikview file.
Please check the sample attached
I am not sure about the utility of this. However, I have tried to get the output (with a not-so meaningful way though).
Check if this helps.
Thanks Tresesco for the swift reply.
This is to convert some excel reports into qlikview without affecting the table structure.
is it possible to create the columns in dimension itself? the attached solution is not so friendly with my table structure
Thanks,
Varun
you can achieve this through inline load