Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to show in a table the Regional sales for ThisYr(2014) and LastYr(2013). Plus a Variance at the end
Region Name | 2013 SALES | 2014 SALES |
---|---|---|
Berkshire | $100 | $200 |
Bucks | $50 | $150 |
Bedfordshire | $400 | $300 |
The data is stored by transaction date in an Xls sheet, which I have been able to convert to via the Load script to Month, Quarter and Year. In Qlik View it appears you are able to use variables to achieve this. How would this problem be approached in Qlik sense.
Thanks
Hello Ankit - I will bump this topic - can someone assist Ankit?
In the mean-time, I believe you would need to pivot this data first into a de-normalized table. Take a look at this video to get an idea: Qlik Sense 3.1 - Using Unpivot (video)
Mike