topic Re: Chart Expression in QlikView

Chart Expression

dunnalahk123 — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Chart Expression

sunny_talwar — Thu, 08 Feb 2018 17:43:02 GMT

How about this?

Re: Chart Expression

dunnalahk123 — Thu, 08 Feb 2018 17:50:04 GMT

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,

Re: Chart Expression

sunny_talwar — Thu, 08 Feb 2018 17:51:36 GMT

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

Re: Chart Expression

dunnalahk123 — Thu, 08 Feb 2018 17:54:33 GMT

Sure Sunny. Thank You so Much.

Re: Chart Expression

sunny_talwar — Thu, 08 Feb 2018 17:58:27 GMT

Added a new table in the script

LOAD * INLINE [

Dim

];

Re: Chart Expression

dunnalahk123 — Thu, 08 Feb 2018 18:03:50 GMT

Thanks a lot Sunny 🙂

i will try to understand what you did.

Re: Chart Expression

dunnalahk123 — Mon, 26 Feb 2018 09:11:44 GMT

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

Re: Chart Expression

sunny_talwar — Mon, 26 Feb 2018 10:03:08 GMT

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

Re: Chart Expression

dunnalahk123 — Mon, 26 Feb 2018 10:17:41 GMT

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.

Re: Chart Expression

sunny_talwar — Mon, 26 Feb 2018 12:19:32 GMT

Added Only({1} ...) to the Dim after Pick... does the image below look like what you wanted?

Pick(Only({1}Dim),

...

Re: Chart Expression

dunnalahk123 — Mon, 26 Feb 2018 12:41:39 GMT

Hi Sunny,

Thank you so much for your kind help.

Yes, I guess Quarter is function is working .

but Year Function still not working and QoQ is gone with latest change.

but if some one select Q4 it should give Q4 Fy17 to Q4Fy16 which is 5 Quarters as we are still not in Q4 Fy18.

if some one select Q3 it should give me Q3Fy17 to Q3Fy16 which is 5 Quarters as we are still not in in Q3Fy18

So above is working as per your File for Quarter.

But

Year Function still not working and QoQ is gone with latest change.

in the same way if some one select directly FY17 from year in FY17 Max Quarter is Q4 so again it should give me Q4FY17 to Q4FY16.

in the same way if some one select directly FY18 from year in FY18 it should give current max quarter to back rolling of 5 Quarters.

So current max Quarter is Q1 So it should roll back to Q1FY18 to Q4FY17

Best Regards,

Re: Chart Expression

sunny_talwar — Mon, 26 Feb 2018 12:44:15 GMT

You can use set analysis for that. Look at this thread Dates in Set Analysis which will help you with set analysis on the date fields.