Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
I have a requirement where I have to keep one line between the country values and the states should start after spacing. Currently my straight table looks as below:
Region Sales Units
USA 100 200
MA 20 50
PA 40 20
CT 30 50
NJ 10 80
Australia 80 100
NT 20 50
SA 30 10
WA 20 50
AAT 10 10
I need the output as shown below(line between 2 countries) and the States should start with some spacing in the left.
Region Sales Units
USA 100 200
MA 20 50
PA 40 20
CT 30 50
NJ 10 80
Australia 80 100
NT 20 50
SA 30 10
WA 20 50
AAT 10 10
Please note that the Region is a single dimension with Countries and States in it. There are a lot of such countries with different states in this Region dimension.
Is this something we can achieve in Qlikview without using In-line load?
Thanks
Samy
Yes, you can use an excel file instead of an inline load. See this blog post How IntervalMatch Solved My Profit and Loss Dilemma