topic Re: How to get a column based on another derived column in QlikView

How to get a column based on another derived column

diwakarnahata — Wed, 15 Oct 2014 11:22:34 GMT

Hi,

Please refer the below image where i have created a sequence number (Sno) for WeekID.

I have a straight table (below) where i have dynamically created a dimension which buckets the selected weeks into group of 4 using the sequence number of the Week. Now i have the sequence number in the column (based on the WeekIDs selected). How do i show the WeekID or WeekDesc corresponding to it.

For e.g. in the below straight table example, I want to show the WeekID (or WeekDesc) corresponding to the Sno 8,12,16 displayed.

Thanks,

Diwakar

Re: How to get a column based on another derived column

tcullinane — Wed, 15 Oct 2014 11:40:02 GMT

If you give the expressions in the table a name you can use that in another expression:

eg. if(WeekSno=Sno,WeekID)

Re: How to get a column based on another derived column

diwakarnahata — Wed, 15 Oct 2014 11:50:34 GMT

Hi Thomas,

Thank you for your response, but there is a small issue with that approach.

In the dynamic dimension expression (as shown in the image previously) I have used a class function which created buckets of four Sequence numbers(Sno), and extracted the highest Sno (using Subfield function) and wanted to replace it with WeekID or WeekName.

But the if() condition replaces the bucket with the Week dimension as a result the Expression is calculated on the Week Level instead of a 4 week rolling sum.

Let me know how this could be fixed?

Thanks,

Diwakar

Re: How to get a column based on another derived column

diwakarnahata — Mon, 20 Oct 2014 06:52:22 GMT

Hi,

Any idea how the above could be achieved?

The previously mentioned solution won't work as the if() function changes the level of the Dimension.

Also, I don't want to superimpose two charts, since I have to put this in a container.

Any suggestions would help.

Thanks,

Diwakar