Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

How to make both my Table 1 & 2 overall amount same ?

Hi All


I have modify the Table 2 Dimension expression on new product script by adding addition filter for month_n > 3 consider new productr, it work fine :-


if(L_issue = '00/00/0000' AND L_move <> '00/00/0000' AND Month_n > '3', ('New Product'),


Note from Table 1 new product amount from 130,468 reduce to Table 1 39.551 , Total amount reduce = 90,917


Below is my Table 2 org script for <6 Mth :-


If([No of Months_] >= 1 and [No of Months_] <= 6, Dual('<6 Mth', 1),


Now i need to add the below new condition into above <6 Mth script.


So i assume it should be like below :-


If([No of Months_] >= 1 and [No of Months_] <= 6 and L_issue = '00/00/0000' AND L_move <> '00/00/0000' AND Month_n < '4', Dual('<6 Mth', 1),


( I include new product month_n < 4 to <6 Mth  )


But it does not work.


If it work , Table 2 should display :-


<6 Mth amount = 718,570 (536,736 + 90,917) , now it display 536,736 is worng 


My objective is make table 1 and 2 overall total amount same.


Hope some one can advise me where i go wrong ?


PAul Yeo


1 Solution

Accepted Solutions

Re: How to make both my Table 1 & 2 overall amount same ?

Does it mean this?

If(([No of Months_] >= 1 and [No of Months_] <= 6) and L_issue = '00/00/0000' AND L_move <> '00/00/0000' AND Month_n < 6, Dual('<6 Mth', 1),

Life is so rich, and we need to respect to the life !!!
5 Replies
paulyeo11
Valued Contributor II

Re: How to make both my Table 1 & 2 overall amount same ?

my QVW

Re: How to make both my Table 1 & 2 overall amount same ?

Does it mean this?

If(([No of Months_] >= 1 and [No of Months_] <= 6) and L_issue = '00/00/0000' AND L_move <> '00/00/0000' AND Month_n < 6, Dual('<6 Mth', 1),

Life is so rich, and we need to respect to the life !!!
paulyeo11
Valued Contributor II

Re: How to make both my Table 1 & 2 overall amount same ?

Hi Anil

It does not get the correct figure. I need to spend more time to analyse your expression.

Paul

Re: How to make both my Table 1 & 2 overall amount same ?

I don't have access your application now? So, I can't look. can you tell me exactly what r u trying

Life is so rich, and we need to respect to the life !!!
paulyeo11
Valued Contributor II

Re: How to make both my Table 1 & 2 overall amount same ?

I see . how you develop this skill ? can you share with me pls.

Community Browser