I am trying to show the Quaterly and 3 months of data in one bar chart when selecting a specific Quater (example: Q1 and display Jan,Feb,March and Q1 data). Any help for the logic would be appreciated.
I was looking at the solution offered here and have been wondering on the usage of Pick Function here , Pick is taking the value of Dim to choose the Dimension YearMonth or Year Quarter but in this case Dim does not have any value selected which evaluates to Null but still the Pick variant seem to give the desired result.
So could you kindly explain how this is been achieved?
I am using personal edition of qlikview, i am unable to open the QVW file which you have shared.
Can you please explain little bit more to achieve this scenario.
How both will come in 1 bar chart.
Well, actually I learnt this method for another expert, when I saw the method he used, I think that's really cool.
It uses the Cartesian Product, the value of Dim only have 1 and 2.
You can pull out a table box including Dim column and Month column and Quarter column.
Then you can see the Cartesian Product for these 3 columns,
And using Pick() function, it can show both month and quarter.
Pick(parameter,exp1,exp2,exp3) - to calculate the expression based on the first parameter value,
eg: parameter = 1, show exp1
parameter = 2, show exp2
So when Dim = 1, show month, when Dim = 2, show quarter
Hope I have clarified the solution
Thanks for taking time and explaining the methodology here, I still have a Question, could you please be kind and reply to it as well:
1. why are we concatenating YearQuarter with Space like YearQuarter&' ' , in the calculated dimension.