topic Re: How to Shift dimension description one position to the left ? in QlikView

How to Shift dimension description one position to the left ?

yanivvl0 — Sun, 18 Sep 2016 09:01:04 GMT

hi everybody,

we have a dimension - code and value ( 1,2,3,4 ) ( bad,good,better,best ).

is it possible to see on chart the sum of ( 1,2,3 ) BUT with description ( good,better,best ).

dont ask me why ..

thanks.

Re: How to Shift dimension description one position to the left ?

marcus_sommer — Sun, 18 Sep 2016 09:15:27 GMT

You could use dual() for it like:

...

if(code = 1, dual('bad', 1),

if(code = 1, dual('good', 2),

if(code = 1, dual('better', 3),

if(code = 1, dual('best', 4))))) as CodeAndDescription,

...

- Marcus

Re: How to Shift dimension description one position to the left ?

sunny_talwar — Sun, 18 Sep 2016 11:07:30 GMT

If you don't want to do this in script, you can use this as your dimension

Pick(code, 'Good', 'Better', 'Best')

Re: How to Shift dimension description one position to the left ?

sunny_talwar — Sun, 18 Sep 2016 11:08:17 GMT

Marcus -

I think you forgot to change the code for each of the if

if(code = 1, dual('bad', 1),

if(code = 2, dual('good', 2),

if(code = 3, dual('better', 3),

if(code = 4, dual('best', 4))))) as CodeAndDescription,

Re: How to Shift dimension description one position to the left ?

marcus_sommer — Sun, 18 Sep 2016 11:31:24 GMT

Of course you are right. I was too sloppy with copy & paste ...

- Marcus

Re: How to Shift dimension description one position to the left ?

yanivvl0 — Sun, 18 Sep 2016 12:00:57 GMT

yea ..

Re: How to Shift dimension description one position to the left ?

swuehl — Sun, 18 Sep 2016 12:02:48 GMT

Yaniv,

you want to sum codes, and then show the description?

The sum could easily be larger than the max code, right? What would be the description then?

Or do you want to calculate the average and show the corresponding description (for the rounded average)?

What is the context you are using the sum/ average? What is the dimension you are using in your chart?

And what is the title of this post telling with regard to the rest of your post?

A lot of open questions to me.

If you want to lookup a description based on your aggregated code, you could maybe use Only() function or FieldValue()/FieldIndex(), like discussed in

Missing Manual - FieldIndex()

Re: How to Shift dimension description one position to the left ?

yanivvl0 — Mon, 19 Sep 2016 05:56:03 GMT

HI Stefan , thanks for help!