topic Please explain simple logic in QlikView

Please explain simple logic

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

Hi All,

I have below simple table.

Load * Inline [

Head Create ,Item Create
12/2/2024, 12/2/2024
12/4/2014,
2014

];

Comparing two dates and expected o/p is below

Yes	1
No	2

To get above o/p i have used the expression =if([Head Create]=[Item Create],'Yes','No') in calculated dimension and

= count(if([Head Create]=[Item Create],'Yes','No')) as expression. Could some explain what happens with this expression

Re: Please explain simple logic

sunny_talwar — Mon, 09 Dec 2019 13:57:34 GMT

I don't think you really need this... I think Sum(1) should work for you as well... In fact you can perform the calculated dimension operation in the script and use it as a field

Table: LOAD *, If([Head Create] = [Item Create], 'Yes', 'No') as MatchFlag; LOAD * INLINE [ Head Create, Item Create 12/2/2024, 12/2/2024 12/4/2014 2014 ];

Re: Please explain simple logic

Brett_Bleess — Tue, 17 Dec 2019 16:15:02 GMT

Priya, did Sunny's example app and explanation get you a working use case? If so, do not forget to return to your thread and use the Accept as Solution button on Sunny's post to give him credit for the assistance and let other Community Members know this worked for the use case. If you are still needing further help, please leave an update.

One area you may to spend some time browsing is the Design Blog, here is the base URL for that area, you can use it to search just this area to find how-to posts that may help on future endeavors.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett