topic Re: Assigning a value to Pivot in QlikView

Assigning a value to Pivot

ferha_jafri — Sat, 16 Nov 2024 00:13:20 GMT

Hello Experts,

I need your help , in the attached application I want to assign time T2 and T3 value for time T1 and I am using T1 as dimension. I want in that way without using creating data island , so please let me know whether it is possible or not without data island. I am sure somebody has a solution to it.

Thanks in advance

Ferha

Re: Assigning a value to Pivot

vivek_gajjar01 — Thu, 30 Jul 2020 15:26:11 GMT

If I've understood your question correctly. Then try the following expression:

If(Time='T1',sum(aggr(Sum({<Time = {'T2','T3'}>}ID),Product)))

Re: Assigning a value to Pivot

dplr-rn — Thu, 30 Jul 2020 15:40:10 GMT

try attached. updated the expression

Re: Assigning a value to Pivot

ferha_jafri — Thu, 30 Jul 2020 16:16:14 GMT

Not getting the desired ans in the application , not sure what is going wrong.

Re: Assigning a value to Pivot

dplr-rn — Thu, 30 Jul 2020 16:19:25 GMT

whats your desired output?

Re: Assigning a value to Pivot

ferha_jafri — Thu, 30 Jul 2020 16:31:19 GMT

If(Age_Band_Dispatched='Dispatched on T+0',sum(aggr(Count({<Age_Band_Dispatched = {'Dispatched by T+1','Dispatched by T+2'}>}Conf_ID),Conf_ID)))

Using this expression but not getting the desired result

Re: Assigning a value to Pivot

dplr-rn — Thu, 30 Jul 2020 16:34:11 GMT

you really need to provide more details. the expression seems to nothing to with the sample app.

share a sample app which represents your data properly. share what the desired output it and then we will be able to help.

Re: Assigning a value to Pivot

ferha_jafri — Thu, 30 Jul 2020 19:23:44 GMT

Hello ,

Now in the attachment I want in the column Dispatched by T+1 Have value Count ID for 'T+2',T>2'

Thanks

Re: Assigning a value to Pivot

Kushal_Chawda — Fri, 31 Jul 2020 00:02:54 GMT

see attached

Re: Assigning a value to Pivot

ferha_jafri — Fri, 31 Jul 2020 01:02:42 GMT

No , not the desired result as I want to have column in the pivot only and in Column T+0 i WANT T+1 + T+2 = 2606

Re: Assigning a value to Pivot

ferha_jafri — Fri, 31 Jul 2020 03:38:37 GMT

Is it possible to have this result in qlikview or not.

Re: Assigning a value to Pivot

Kushal_Chawda — Fri, 31 Jul 2020 08:48:29 GMT

It is possible but you may need to use data island to achieve it.

Re: Assigning a value to Pivot

Kushal_Chawda — Fri, 31 Jul 2020 11:02:32 GMT

See the attached if it helps. I have created one inline table just for making require dimension. This inline is not used for any selections. Hence, there is no harm of using it as other selections will work as expected.

Re: Assigning a value to Pivot

ferha_jafri — Fri, 31 Jul 2020 11:07:19 GMT

Thanks Kush..with data island , it will work ,but thanks again.

Re: Assigning a value to Pivot

Kushal_Chawda — Fri, 31 Jul 2020 11:10:05 GMT

Yes. but method I used in not complete Data Island. Generally data Island used for particular selections which I am avoiding here