Chart Expression

[dunnalahk123]

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

[sunny_talwar]

How about this?

[dunnalahk123]

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,

[sunny_talwar]

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

[dunnalahk123]

Sure Sunny. Thank You so Much.

[sunny_talwar · Accepted solution]

Added a new table in the script

LOAD * INLINE [

    Dim

    1

    2

    3

    4

    5

];

[dunnalahk123]

Thanks a lot Sunny 🙂

i will try to understand what you did.

[dunnalahk123]

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

[sunny_talwar]

What are you hoping to see after selection? Can you share the expected output based on any one or two selection/s

[dunnalahk123]

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.