Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can Some one help me how can i add QoQ in first table next to last quarter
in above chart expression i just moved my Quarter dimension from vertical to column , so quarters coming as i needed.
but only one thing is i need to add QoQ end of that, i have the logic and expression ready .
but not sure how to add it. for your reference i am attaching qvw file . can some one help me please.
Best Regards,
hK
How about this?
Hi Sunny,
Thank you so Much for your prompt response.
Super , that's what i need exactly.
i want for QoQTrend and YoY and YoYTrend as well. can you help me with that as well.
mean while can you teach me If(SecondaryDimensionality() = 0, how it works?
Best Regards,
You can read about secondaryDimensionality() here:
The second dimension... or how to use secondarydimensionality()
This solution will have to change based on the new request... will be back with the other way to do this
Sure Sunny. Thank You so Much.
Added a new table in the script
LOAD * INLINE [
Dim
1
2
3
4
5
];
Thanks a lot Sunny 🙂
i will try to understand what you did.
Hi Sunny,
I have Question again.
Following with above Conversation.
=Pick(Dim, Quarter,'QoQ', 'Trend.', 'YoY', 'Trend')-- this is what we have given earlier.
but now i added one variable in place of Quarter
=Pick(Dim, ($(vRollingQuarter)), 'QoQ', 'Trend.', 'YoY', 'Trend')-- which will give me always 5 rolling Quarters.
but now pick function is not working if i select dimension of Quarter.
For your reference i added my QLikview application above in original Post
What are you hoping to see after selection? Can you share the expected output based on any one or two selection/s
Hi Sunny,
Thank you so much for your response.
i added QVW in original post attachment in details. if you open you will see it.
Thanks.